|
 |
asp_web_howto thread: rsRecordset.RecordCount
Message #1 by "Oliver Dempsey" <odempsey@b...> on Fri, 29 Dec 2000 20:32:48 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0043_01C071D6.82532140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Why do I get a value of -1 when I put in this code:-
rsRecordset.RecordCount
Regards
Oliver Dempsey
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "Majid Qazi" <majid@i...> on Sat, 30 Dec 2000 13:26:59 -0500
|
|
If you are not using a cursor type such as keyset, the RecordCount
property of an ADO Recordset shows a value of -1
Majid Qazi
----- Original Message -----
From: Oliver Dempsey
To: ASP Web HowTo
Sent: Friday, December 29, 2000 3:32 PM
Subject: [asp_web_howto] rsRecordset.RecordCount
Why do I get a value of -1 when I put in this code:-
rsRecordset.RecordCount
Regards
Oliver Dempsey
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #3 by "Martin McIntyre" <martin@m...> on Sun, 31 Dec 2000 00:46:34 -0000
|
|
You get this when you open your recordset with a certain cursor. (Dynamic
think, I can dig it out if you like)
If you open it in a different mode (i.e. Keyset / forward only) this
should give you the correct count.
Try different types until it works. If you need a writable recordset, then
you cannot use the .recordcound property. (It's all to do with speed. The
recordset can only determine the number of records if it goes to the end to
find out)
Hope this helps.
Martin
-----Original Message-----
From: Oliver Dempsey [mailto:odempsey@b...]
Sent: 29 December 2000 20:33
To: ASP Web HowTo
Subject: [asp_web_howto] rsRecordset.RecordCount
Why do I get a value of -1 when I put in this code:-
rsRecordset.RecordCount
Regards
Oliver Dempsey
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #4 by "Skip Kirby" <cfkirby@p...> on Sun, 31 Dec 2000 03:46:44 -0000
|
|
I believe it has to do with the (default) cursor type. Try specifying a
cursor type other than the default. Here's an MSDN link that should help:
http://msdn.microsoft.com/library/books/dnjet/c9_body_81.htm
Cheers!
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #5 by "Skip Kirby" <cfkirby@p...> on Sun, 31 Dec 2000 04:34:32 -0000
|
|
...and here's an even better explanation of what's going on vis a vis the
RecordCount property and cursor types:
http://msdn.microsoft.com/library/officedev/office97/output/F1/D2/S5A2E3.HTM
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
