ADO RecordCount Property
 Complete Recordset Object Reference
The RecordCount property returns a long value that indicates the number of records
in a Recordset object.
If the Recordset object supports AbsolutePosition and AbsolutePage properties or
bookmarks (if Supports(adApproxPosition) or Supports(adBookmark) returns true),
this property will return the exact number of records in the Recordset.
Note: This property will return -1 for a forward-only cursor; the actual count for a static or keyset cursor; and -1 or the actual count for a dynamic
cursor.
Note: The Recordset object must be open when calling this property. If
this property is not supported it will return -1.
Syntax
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM Customers"
rs.Open sql,conn
if rs.Supports(adApproxPosition)=true then
i=rs.RecordCount
response.write("The number of records is: " & i)
end if
rs.Close
conn.Close
%>
|
Complete Recordset Object Reference
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
