can't get recordcount property to work!!

[Navin Kulshreshtha]

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

 

[Ray at]

Response.Write osRecordSet.Recordcount
This line always returns -1.

http://www.aspfaq.com/2193

Ray at work

 

[Navid]

Hi,

Just Change osRecordset.Open strSQL, strConnect to
osRecordset.Open strSQL, strConnect,1,3
Thats All!

-Nav!d