Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identify The Number Of Records In A Recordset

Status
Not open for further replies.
Skittle

Skittle

ISP
Sep 10, 2002
1,528
US
Is there a way of telling how many records are in a record set without reading through the entire set or executing an SQL statement to return a single summary record with a count?


 
Sort by date Sort by votes
Open your recordset with an adOpenStatic cursorType and you can use the following...
Code: 
Dim intCount, objRecordset

Set objRecordset = Server.CreateObject("ADODB.Recordset")
...etc...rest of code to open your recordset...

intCount = objRecordset.RecordCount
Tony
reddot.gif WIDTH=500 HEIGHT=2 VSPACE=3

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
767
leifoet
leifoet
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
363
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
402
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
416
leifoet
leifoet
leifoet
  • Locked
  • Question
How to update the content of radio buttons in a database?
Replies
2
Views
265
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top