Hi,

How do I know how many records are in my recordset?



Like: I have this query running in ASP


set rs2 = server.CreateObject("adodb.recordset")
RS2.open "SELECT id FROM tblcontest", conndb
response.Write rs2.recordcount

I get the result as -1 but I want to know how many total number of records are there in my recordset.

I hope u understand wot I mean.


Thanx






-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

If RECORDCOUNT gives you a result 1 that's the total number of records in your RECORDSET.

=======================
Strange and crazy, but everything is possible

No its showing me -1 and not 1

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Try this.

RS2.open "SELECT id FROM tblcontest", conndb, 3, 3
Response.Write rs2.recordcount