Recordcount return -1 with ASP

[Dayron]

I discovered that my asp code retrieve the record from the database and
I wish to get the recordcount of the record. Unfortunately, I always get
-1 instead of the correct record count.

I have try to use the below statement which I search through the forum
and this is the only answer for getting the recordcount property. but i
still cannot get the actual count. can i know why?

rst.Open strSQL, connection, 3, 3

 

[Guest]

rst.Open strSQL, connection, 3, 3
rst.MoveLast
Then you can get recordcount

 

[Mark]

Checkout

http://www.aspfaq.com/show.asp?id=2193

Cheers
Mark