|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
January 9th, 2004, 11:51 PM
|
|||
|
|||
Can't get objRS.recordcount!!
Hello. I'm simply trying to get the recordcount of a query. I've set my cursors properly (client-side) and I still get -1. This is part of my code:
sql = "SELECT * FROM subCatTbl" objRS.CursorType = adOpenStatic set objRS=objConn.Execute(sql) response.write objRS.recordcount I get -1. Can anyone please help. Thanks.
|
|
#3
January 23rd, 2004, 09:56 AM
|
|||
|
|||
|
I had the same problem. In your connection specific the CursorLocation to adUserClient (3). For some strange reason, mySQL does not support Server Side Cursors, and by default, this is the Cursor Type used by ASP.
This took me four hours to find, hope you have more luck than i did.
|
|
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Can't get objRS.recordcount!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
