how many results in recordset?

[vchatlive]

Im trying to find a way to accomplish something and i need to know how many records are in a recordset once i pull it from a database. right now i know there are 3 , but i cant get it to tell me that.. i tried msgbox rsNews.recordcount but that shows -1 all the time. Any ideas on how i can get an accurate count of how many are there?

Thanks

[vchatlive]

quick note: im using adodb / mysql / odbc3.51 / vb6

[Hack]

Use a static cursor and the RecordCount will work.

You can also do a SELECT COUNT(*) WHERE and use the same WHERE criteria that you have in the SELECT statement that creates your recordset.

[vb5prgrmr]

Rs.MoveLast
MyVariable = Rs.RecordCount
Rs.MoveFirst

is another way...



Good Luck

[dilC85]

open the recordset like following

RS= SqlQuery,connection,adopenstatic,adlockreadonly
Dim count as integer
count=RS.Recordcount.