Hi,

How do you get how many records in a recordset...

Set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql,db

I try the following, and it gives me -1, but I *know* that there are 4 records in the sql query that I'm testing...

response.write rs.RecordCount

Tried
rs.Count, and I get the following error...


Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'rs.Count' /dev/tab_test1.asp, line 12

When you just do
you get a FORWARD ONLY cursor, and you can't get the record count from such a cursor. You need to use a STATIC cursor, via adOpenStatic. Or, in practical terms:

Or if you are cycling through the records anyway just add a manual count.