Hi folks, I'm opening a recordset with a SQL statement and then trying
to use the .RecordCount property to count the number of rows in the
recordset. For some reason, it is always returning -1. Here's the code
(I have left out the details for the connection string):
-------------------
strSQL = "SELECT * from orders"
strConnect = [details removed]
Set osRecordSet = Server.CreateObject("ADODB.Recordset")
osRecordset.Open strSQL, strConnect
Response.Write osRecordSet.Recordcount & "<br>"
-------------------
This last line always returns -1. Please help!!
Thanks,
Navin