Determining Record Count and Record Number

[RickLiebespach]

Question:
How do I determine how many records are in my RecordSet?
and
How do I determine what is the record number of the record I am currently on?

What I want to accomplish is to be able to tell the user that they are currently on record 5 of 23,217
or something like that.


Rick Liebespach

http://www.omniagroup.com

http://www.careermaze.com

 

[mwolf00]

easiest way is to load the into an array using getRows()

set rs = cn.execute("select * from myTable&quot
allRows = rs.getRows()

ttlCount = uBound(allRows,2) + 1

for x = 0 to uBound(allRows,2)
response.write "you are on row " & x & " of " & ttlCount
next



Are you paging your results? 23K records - you should page...


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[RickLiebespach]

I'm not sure your solution will completely meet my need.
I can get the record count by opening static and doing
objRecordSet.RecordCount

But I'm not sure I can get the current record number...
Part of what I'm doing is using
objRecordSet.Find

objRecordSet.Find "Unique_ID = '" & Session("Notes_Unique_ID&quot & "'"

and I'd like to know the record number of the record I just found.

Any ideas?
TIA,
Rick

Rick Liebespach

http://www.omniagroup.com

http://www.careermaze.com

 

[mwolf00]

Does this help?

http://www.devguru.com/Technologies/ado/quickref/recordset.html

AbsolutePosition Property
Sets or returns a long value that is the ordinal position of the cursor.

Syntax: recordsetobject. AbsolutePosition

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[RickLiebespach]

Yes.
That got it.
Thanks!

Rick Liebespach

http://www.omniagroup.com

http://www.careermaze.com

 

[gjconely]

Do a SELECT COUNT(*) FROM ??? to return the number of records. Then simply keep a counter on what record you are on. The AbsolutePosition does not work well if you are doing anything except Access databases. - Some drivers return erroneous or no information for this property.


Greg Conely

http://www.ImageMentor.net