[thelist] Number of records returned

[Chris W. Parker]

another thing you want to do is dump all your records into an array and
then loop through the array when printing(to the screen of course). why?
because it's a lot faster and keeps the recordset open for a much
smaller period of time.

like so...

Set rsMyRecordSet = Server.CreateOjbect("ADODB.RecordSet")

rsMyRecordSet.Open sql, <string>

rsMyRecordSetArr = rsMyRecordSet.GetRows()



you can learn a lot about it at http://www.asp101.com/ also i think
aspfaq has something on it.

just search for "getrows asp recordset" or some derivative of that.


hope that helps,

chris.

> -----Original Message-----
> From: David at softv.net [mailto:David at softv.net]
> Sent: Thursday, August 15, 2002 8:23 AM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Number of records returned
>
>
> Hi Chris,
>
> It depends on the type of cursor that you have opened the
> recordset with.
> You should use a keyset or static cursor. For example,
>
> RS.Open SQL, Connection, adOpenStatic, adLockReadOnly
>
> Also keep in mind that the recordset must be open at the time
> that you check
> the recordcount property.
>
> Dave
> http://java.dbmdata.com
>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>