ADO PageCount Property

Complete Recordset Object Reference

The PageCount property returns a long value that indicates the number of pages with data in a Recordset object.

Tip: To divide the Recordset into a series of pages, use the PageSize property.

Note: If the last page contains fewer records than specified in PageSize, it still counts as an additional page in the PageCount property.

Note: If this method is not supported it returns -1.

Syntax

objRecordset.PageCount

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

rs.PageSize=5

i=rs.PageCount
response.write("The number of pages in RS=" & i)

rs.Close
conn.Close
%>

Complete Recordset Object Reference

Altova® XMLSpy® - The world's best-selling XML editor!

Whether you're new to XML or already an advanced user, the user-friendly views and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to meet your XML and Web services development needs from start to finish.

• XML editor
• Graphical XML Schema / DTD editors
• XSLT 1.0/2.0 editor, debugger, profiler
• XQuery editor, debugger, profiler
• Support for Office Open XML (OOXML)
• Graphical WSDL editor & SOAP debugger
• Java, C#, C++ code generation
• And much more!

Download a fully functional free 30-day trial today!