Record Set .RecordCount

[dogfish227]

set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM pics"
rs.Open sql,objConn
response.write(rs.Fields("picture").Value)
i=rs.RecordCount
response.write("The number of records is: " & i)
rs.Close

what is wrong with the code above im am useing to get the number of records.

i want it to write 1 b/c there is one record in the table.

the SQL is defiantly right b/c response.write(rs.Fields("picture").Value) write out the value of the one thng in the database

but RecordCount is giveing me -1 why is this???

[Brandoe85]

What cursor style are you using? RecordCount only works with certian cursor styles, would be better off to use count() to get the record count.

[RobDog888]

When you dont pass the lock type and cursor type parameters the defualt is a forward only readonly recordset that
does not support the .Recordcount property.

Try using
rs.Open sql,objConn, adOpenKeyset, adLockOptimistic, adCmdText

[Jeaysindh]

hi deae

fs
fsd
f
dsf
sd
sd
s
f
sf
sa
fsdsdfsafsfaf