Strange value returned from recordcount

[Jeff Boyer]

Hello everyone,
Can someone tell me why a ADO recordset.recordcount would return a -1? I
have confirmed that it has records in it by writing some values to the
screen. Why can't I count the number of records returned though?
Please help,
Jeff

P.S.
I am using VBScript for my code connecting to a SQL Server 2000 database

 

[Aaron Bertrand [MVP]]

http://www.aspfaq.com/2193