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.CreateOb ject("ADODB.Rec ordset")
osRecordset.Ope n strSQL, strConnect

Response.Write osRecordSet.Rec ordcount & "<br>"
-------------------

This last line always returns -1. Please help!!

Thanks,
Navin

[Ray at]

"Navin Kulshreshtha" <am*******@hotm ail.com> wrote in message

Response.Write osRecordSet.Rec ordcount
This line always returns -1.

http://www.aspfaq.com/2193

Ray at work

[Peter Foti]

"Navin Kulshreshtha" <am*******@hotm ail.com> wrote in message
news:d1******** *************** ***@posting.goo gle.com...

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.CreateOb ject("ADODB.Rec ordset")
osRecordset.Ope n strSQL, strConnect

Response.Write osRecordSet.Rec ordcount & "<br>"
-------------------

This last line always returns -1. Please help!!

I'm just taking a stab in the dark, but I usually create a recordset using
the Execute method of the Connection object. Maybe try doing that instead?

Replace this line:

osRecoredset.Op en strSQL, strConnect

with these:

Set dbConn= Server.CreateOb ject("ADODB.Con nection")
dbConn.Open strConnect
Set osRecordset = dbConn.Execute( strSQL, , adCmdText)

And then don't forget to close the dbConn (and set to Nothing) when done.

See if that works?

Good luck.
Peter Foti

[Peter Foti]

"Navin Kulshreshtha" <am*******@hotm ail.com> wrote in message
news:d1******** *************** ***@posting.goo gle.com...

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.CreateOb ject("ADODB.Rec ordset")
osRecordset.Ope n strSQL, strConnect

Response.Write osRecordSet.Rec ordcount & "<br>"
-------------------

This last line always returns -1. Please help!!

Just read some more on this... if a forward-only cursor is being used,
then -1 is returned. I suspect that is your problem. You can find some
good info on this at:
http://www.devguru.com/Technologies/...cordcount.html

And for general ADO:
http://www.devguru.com/Technologies/...ado_intro.html

Regards,
Peter Foti

[Navid]

Hi,

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

-Nav!d

"Navin Kulshreshtha" <am*******@hotm ail.com> wrote in message
news:d1******** *************** ***@posting.goo gle.com...

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.CreateOb ject("ADODB.Rec ordset")
osRecordset.Ope n strSQL, strConnect

Response.Write osRecordSet.Rec ordcount & "<br>"
-------------------

This last line always returns -1. Please help!!

Thanks,
Navin