Use the RecordCount property to find out how many records are in a Recordset
object. The property returns -1 when ADO cannot determine the number of
records or if the provider or cursor type does not support RecordCount.
Reading the RecordCount property on a closed Recordset causes an error.
If the Recordset object supports approximate positioning or bookmarks—that
is, Supports (adApproxPosition) or Supports (adBookmark), respectively,
return True—this value will be the exact number of records in the Recordset
regardless of whether it has been fully populated. If the Recordset object
does not support approximate positioning, this property may be a significant
drain on resources because all records will have to be retrieved and counted
to return an accurate RecordCount value.
The cursor type of the Recordset object affects whether the number of
records can be determined. The RecordCount property will return -1 for a
forward-only cursor, the actual count for a static or keyset cursor, and
either -1 or the actual count, depending on the data source, for a dynamic
cursor.
================================
http://www.ASPkey.net/
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
================================
"Jeff Boyer" <jeff@jdboyer.com> wrote in message
news:fIsAb.585776$9l5.117152@pd7tw2no...[color=blue]
> Hello everyone,
> Can someone tell me why a ADO recordset.recordcount would return a -1? I
> have confirmed that it has records in it by writing some values to the
> screen. Why can't I count the number of records returned though?
> Please help,
> Jeff
>
> P.S.
> I am using VBScript for my code connecting to a SQL Server 2000 database
>
>[/color]
