Source Code for http://authors.aspalliance.com/brettb/EasyADORecordSetPaging.asp
<html>
<!--Begin ASPAlliance Document Header-->
<head>
<title>Easy ADO RecordSet Paging</title>
<link type="text/css" rel="stylesheet" href="ASPKitchen.css" />
<meta name="description" content="Sample VBScript code showing how to page ADO RecordSets with the minimum of fuss">
<meta name="keywords" content="ASP, ADO, paging, recordset, recordsets">
</head>
<!--Begin ASPAlliance Document Article-->
<body topmargin="0" leftmargin="0">
<div align="center"><center>
<script language="JavaScript">
function SubmitSearch() {
document.frmSearch.submit();
}
</script>
<table border="0" cellpadding="0" width="100%" cellspacing="0">
<tr>
<td width="30%" bgcolor="#CC0000"><a href="http://authors.aspalliance.com/"><img
src="images/ASPAllianceLogo.gif" width="142" height="57" alt="ASPAlliance" border="0"></a></td>
<td width="40%" bgcolor="#CC0000" align="center"><!-- 468x60 Banner Ad Tag Start -->
<iframe src="http://ads.aspalliance.com/displayad.aspx?t=1&m=1" height="60" width="468" marginwidth="0" marginheight="0" frameborder="0" scrolling="no"><script type="text/javascript" src="http://ads.aspalliance.com/displayad.aspx?t=1&m=1&target=_parent&js=1"></script></iframe>
<!-- 468x60 Banner Ad Tag End --></td>
<td width="30%" bgcolor="#CC0000" align="right" class="HeaderBar"><font size="4">ASP Kitchen</font> <br><form name="frmSearch" method="POST" action="http://www.brettb.com/ASPAllianceSearch.asp">Search: <input type="text" name="Query"> <a href="javascript:SubmitSearch()">Go</a> </form>
</td>
</tr>
<tr>
<td colspan="3" bgcolor="#CCCCCC" style="BORDER: #270D30 1px solid;"><div class="menu-top"
id="TopMenu" align="left"><a href="Default.asp" title="Home"><p>Home</a> | <a
href="ClassicASPArticles.asp" title="ASP Articles">ASP Articles</a> | <a
href="ASP.NetArticles.aspx" title="ASP.NET Articles">ASP.NET Articles</a> | <a
href="Tools.asp" title="Tools">Tools</a> | <a
href="TableOfContents.asp" title="Table Of Contents">Table Of Contents</a> | <a href="What'sNew.aspx" title="What's New">What's
New</a></p>
</div></td>
</tr>
</table>
</center></div>
<table border="0" cellpadding="8" width="100%" cellspacing="0">
<tr>
<td valign="top" align="left"><!--start article-->
<h1>Easy ADO RecordSet Paging</h1>
<h2>Introduction</h2>
<p>This article demonstrates the use of ADO Recordset paging. Paging is invaluable for
splitting up the results of database queries into manageable screens of data.</p>
<h2>Easy Recordset Paging</h2>
<p>The following code will retrieve a Recordset from a data source, then format it in a
table.</p>
<p>The code should work on your system with only minor modifications. The only things you
should need to be changing are the lines that define oConnection (the ADO connection) and
the sSQLStatement SQL query. The oConnection variable should be a connection string. The
sSQLStatement should be a SQL query.</p>
<p>The code has been tested with SQL Server 7.0 and Access 2000 databases, although it
should work with other databases supported by ADO.</p>
<p><font color="#808080"><%<br>
</font><font color="#008000">'Declare variables</font><font color="#808080"><br>
Dim iCurrentPage<br>
Dim iPageSize<br>
Dim i<br>
Dim oConnection<br>
Dim oRecordSet<br>
Dim oTableField<br>
Dim sPageURL<br>
<br>
</font><font color="#008000">'Declare constants</font><font color="#808080"><br>
Const adOpenStatic = 3 'Open a RecordSet using a static cursor<br>
Const adLockReadOnly = 1 'Open a RecordSet in read-only mode<br>
<br>
</font><font color="#008000">'Retrieve the name of the current ASP document</font><font
color="#808080"><br>
sPageURL = Request.ServerVariables("SCRIPT_NAME")<br>
<br>
</font><font color="#008000">'Retrieve the current page number from the QueryString</font><font
color="#808080"><br>
iCurrentPage = Request.QueryString("Page")<br>
If iCurrentPage = "" Or iCurrentPage = 0 Then iCurrentPage = 1<br>
<br>
</font><font color="#008000">'Set the number of records to be displayed on each page</font><font
color="#808080"><br>
iPageSize = 3<br>
<br>
</font><font color="#008000">'An ADO connection string</font><font color="#808080"><br>
oConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
Catalog=pubs;Data Source=PUBS_DATABASE;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID= DATABASE_SERVER; User
Id=PubsDBUser;PASSWORD=gt6Te4Ja;"<br>
<br>
</font><font color="#008000">'An SQL statement</font><font color="#808080"><br>
sSQLStatement = "SELECT * FROM Publishers"<br>
<br>
</font><font color="#008000">'Create an ADO RecordSet object</font><font color="#808080"><br>
Set oRecordSet = Server.CreateObject("ADODB.Recordset")<br>
<br>
'Set the RecordSet PageSize property<br>
oRecordSet.PageSize = iPageSize<br>
<br>
</font><font color="#008000">'Set the RecordSet CacheSize property to the<br>
'number of records that are returned on each page of results</font><font color="#808080"><br>
oRecordSet.CacheSize = iPageSize<br>
<br>
</font><font color="#008000">'Open the RecordSet</font><font color="#808080"><br>
oRecordSet.Open sSQLStatement, oConnection, adOpenStatic, adLockReadOnly<br>
<br>
</font><font color="#008000">'Move to the selected page in the record set</font><font
color="#808080"><br>
oRecordSet.AbsolutePage = iCurrentPage<br>
<br>
</font><font color="#008000">'Display the opening HTML of a table</font><font
color="#808080"><br>
Response.Write "<table border=""0""
width=""50%"" cellpadding=""2""
cellspacing=""0"">"<br>
Response.Write "<tr>"<br>
<br>
</font><font color="#008000">'Loop through the fields in the RecordSet and<br>
'display a column heading for each field</font><font color="#808080"><br>
For Each oTableField In oRecordSet.Fields<br>
Response.Write "<th width=""50%""
bgcolor=""#008080"" align=""left""><font
color=""#FFFFFF""><b>" & oTableField.Name &
"</b></font></th>"<br>
Next<br>
<br>
Response.Write "</tr>"<br>
Response.Write "<tr><td width=""50%""
bgcolor=""#C0C0C0"">"<br>
<br>
</font><font color="#008000">'Use the GetString method to display the database rows<br>
'The GetString method has the following parameters:<br>
'StringFormat = This should be set to 2 (or the adClipString ADO constant)<br>
'NumRows = Number of RecordSet rows to be used<br>
'ColumnDelimiter = Delimiter to be used between columns<br>
'RowDelimiter = Delimiter to be used between rows<br>
'NullExpr = Expression to use for null values</font><font color="#808080"><br>
Response.write oRecordSet.GetString(2, iPageSize, "</td><td
width=""50%"" bgcolor=""#C0C0C0"">",
"</td></tr><tr><td width=""50%""
bgcolor=""#C0C0C0"">", " ")<br>
<br>
Response.Write "</td></tr></table>"<br>
<br>
</font><font color="#008000">'Release database connectivity objects</font><font
color="#808080"><br>
oRecordSet.Close<br>
set oRecordSet = nothing<br>
set oConnection = nothing<br>
%></font><br>
</p>
<h2>How the code sample works</h2>
<h3>Obtaining field names</h3>
<p>A less well known feature of Recordsets is the ability to easily obtain a list of field
names contained within that Recordset. This saves a lot of time, and means that one
results page could potentially be used for the results from different tables. Field names
are obtained from the Fields collection of the Recordset object. Each Field in this
collection has a corresponding Name property which contains the field name. The following
code is used to retrieve a list of field names:</p>
<p><font color="#808080">For Each oTableField In oRecordSet.Fields<br>
Response.Write "<th width=""50%""
bgcolor=""#008080"" align=""left""><font
color=""#FFFFFF""><b>" & oTableField.Name &
"</b></font></th>"<br>
Next</font></p>
<h3>Using the ADO Recordset GetString method</h3>
<p>The conventional method of rendering a Recordset in HTML is to loop through the
records, writing a new table row for each record.</p>
<p>An alternative method is to use the ADO Recordset’s GetString method. This method
also offers improved performance. The GetString method has the following parameters:
<ul>
<li>StringFormat</li>
</ul>
<ul>
<li>NumRows</li>
</ul>
<ul>
<li>ColumnDelimiter</li>
</ul>
<ul>
<li>RowDelimiter</li>
</ul>
<ul>
<li>NullExpr</li>
</ul>
<p><b>StringFormat</b> specifies how the Recordset should be converted to a string. The
parameter should be set to 2 (corresponding to the adClipString ADO constant).</p>
<p><b>NumRows</b> is the number of records that should be converted into the returned
Recordset. In the sample code above, the number of rows are contained in the iPageSize
variable.</p>
<p><b>ColumnDelimiter</b> is the string that should be appended to each column. In this
particular example this is a closing table cell tag (</td>), followed by an opening
table cell tag (<td>).</p>
<p><b>RowDelimiter</b> is the string that is appended to each row. In this example, it is
a closing table cell tag, followed by a closing table row tag (</tr>), then an
opening table row tag (<tr>) followed by an opening table cell tag.</p>
<p>Finally, <b>NullExpr</b> specifies what should be displayed if the particular Recordset
field has a null value. Setting this parameter to " " will add a HTML
non-breaking space, and in Netscape browsers will prevent empty table cells from appearing
blank.</p>
<h3>Navigating around the Recordset</h3>
<p>ADO allows Recordsets to be broken down into sections, called pages. Each of these
pages of results can contain a user-specified number of records. The number of records
contained within each page is controlled by the PageSize property of the Recordset. When
returning a Recordset from the database, the records can be returned from a specific page
by setting the AbsolutePage property.</p>
<p>In the sample code above, the AbsolutePage property is set from the iCurrentPage
variable, which is itself obtained from the Page parameter from the QueryString. In this
way it is possible to introduce page navigation (the code for this is below).</p>
<h3>Adding links to other pages of results</h3>
<p>If you want to add links to all of the other pages of results, then use something like
the following VBScript:</p>
<p><font color="#808080"><%<br>
</font><font color="#008000">'Display a list of links to all of the other pages of results</font><font
color="#808080"><br>
For i = 1 to oRecordSet.PageCount<br>
<br>
If i = CInt(iCurrentPage) Then<br>
Response.Write "[ Page " & i & " ] "<br>
Else<br>
Response.Write "[ <a href=""" & sPageURL &
"?Page=" & i & Chr(34) & ">Page " & i &
"</a> ] "<br>
End If<br>
<br>
Next<br>
%></font></p>
<p>An alternative method of navigation is to use links to the next and previous pages of
results. This is achieved using the following:</p>
<p><font color="#808080"><%<br>
</font><font color="#008000">'If the current page number is less than the<br>
'total number of pages then display a link<br>
'to the next page of results</font><font color="#808080"><br>
If CInt(iCurrentPage) < oRecordSet.PageCount Then<br>
Response.Write "<a href=""" & sPageURL & "?Page="
& (iCurrentPage + 1 ) & """>Next Page</a>"<br>
End If<br>
<br>
</font><font color="#008000">'If the number of the current page is greater than<br>
'the first page then display a link to the previous<br>
'page of results</font><font color="#808080"><br>
If CInt(iCurrentPage) > 1 Then<br>
Response.Write "<a href=""" & sPageURL & "?Page="
& (iCurrentPage - 1 ) & """>Previous Page</a>"<br>
End If<br>
%></font></p>
<h3>Displaying the number of records in the Recordset</h3>
<p>Obtaining the number of records in a Recordset is easily achieved since it is contained
within the RecordCount property of the Recordset object. You can then show the user the
number of records returned, e.g.</p>
<p><font color="#808080"><%<br>
Response.Write("Your search has returned ")<br>
Response.Write(oRecordSet.RecordCount)<br>
Response.Write(" records.")<br>
%></font></p>
<p>The disadvantage of using the RecordCount property is that it is not supported by all
Recordsets.</p>
<h2>Further reading</h2>
<p>Recordset paging is also covered in the following articles:
<ul>
<li><a href="http://authors.aspalliance.com/mbrink1111/getrows/getrows.asp">Mastering the ADO
RecordSet GetRows method</a>.</li>
</ul>
<ul>
<li><a href="http://www.asptoday.com/articles/20000605.htm"
title="Record Navigation System using the ADO Recordset">Record Navigation System using
the ADO Recordset</a>.</li>
</ul>
<ul>
<li><a href="http://www.asp101.com/articles/recordsetpaging/index.asp"
title="Recordset Paging with ADO 2.0">Recordset Paging with ADO 2.0</a>.</li>
</ul>
<ul>
<li><a
HREF="redirector.asp?URL=http://www.amazon.com/exec/obidos/ASIN/0672317907/aspalliance"
title="Sams Teach Yourself Web
Development With ASP in 24 Hours"
title="Sams Teach Yourself Web Development With ASP in 24 Hours">Sams Teach Yourself Web
Development With ASP in 24 Hours</a>. Start learning ASP with this introductory guide.</li>
</ul>
<!--end article-->
<h2>Useful Development Tools</h2>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank" title="ASP Documentation Tool™"><strong>ASP
Documentation Tool™</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Automatically creates developer documentation for ASP 2.0
and 3.0 web applications written in VBScript and JScript. Documentation for Microsoft
Access, SQL Server 7/2000 databases and Visual Basic 6.0 components associated with the
web application can also be incorporated into the reports. Documentation is created in
HTML, HTML Help and plain text formats.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/SampleWeb.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/SampleWeb.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/SampleWeb_Documentation/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASPDocumentationTool_Evaluation_Version.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASPDocumentationTool_Evaluation_Version.zip" title="Download Trial Version">Download
Trial Version</a> (5.2Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.asp" target="_blank" title="Index Server Companion"><strong>Index Server Companion</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">
The Index Server Companion is a Windows application that extends the functionality of Microsoft Index Server so that it is able to index content from remote websites and also from ODBC databases. As such it can be used as a low cost alternative to Site Server 3.0 Search.
</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanionDocumentation.zip"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Product Documentation"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanionDocumentation.zip" title="View Product Documentation">View Product
Documentation</a> (119K ZIP file).<br>
<a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.SampleSearch.asp"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="Try Sample Search Facility"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.SampleSearch.asp"
target="_blank" title="View Sample Search Facility">Try Sample Search Facility</a>.<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanion_EvaluationVersion.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/IndexServerCompanion_EvaluationVersion.zip" title="Download Trial Version">Download
Trial Version</a> (1.7Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.ASPNETDocumentationTool.asp" target="_blank" title="ASP.NET Documentation Tool"><strong>ASP.NET Documentation Tool</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Automatically creates developer documentation for ASP.NET web applications written in C# or VB.NET.
Documentation for SQL Server 7/2000 databases and C#/VB.NET components associated with the
web application can also be incorporated into the reports. Documentation is created in
HTML, HTML Help and plain text formats.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/SampleWeb.NET.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/SampleWeb.NET.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/ASP.NETDocToolSamples/SampleWeb.NET/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASP.NETDocumentationTool_1.0.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/ASP.NETDocumentationTool_1.0.zip" title="Download Trial Version">Download
Trial Version</a> (727K ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp" target="_blank" title="SQL Documentation Tool"><strong>SQL
Documentation Tool</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">The SQL Documentation Tool creates technical documentation for Microsoft SQL Server 7.0 and 2000 databases. Technical documentation is created in HTML and HTML Help formats. The HTML Help format documentation is fully searchable and cross referenced. The SQL Documentation Tool documents SQL Server Tables, Views, Stored Procedures, Triggers and Table Relationships.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Test_Project.chm"><img
src="images/Icon_CHM.gif" width="16" height="16" alt="View Sample Output (HTML Help format)"
border="0" align="absmiddle"></a> <a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Test_Project.chm" title="View Sample Output (HTML Help format)">View Sample
Output</a> (HTML Help format).<br>
<a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/SQLDocumentationTool/Reports/Test_Project/Default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/SQLDocumentationToolTrial.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/SQLDocumentationToolTrial.zip" title="Download Trial Version">Download
Trial Version</a> (10.3Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.asp" target="_blank" title="The Website Utility"><strong>The Website Utility</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">The Website Utility examines websites for errors and
areas that need to be optimised for search engines by using a built in web crawling engine.
Errors checked for include broken or moved hyperlinks, missing page titles and missing meta tags.
It also generates HTML for use in creating website site maps (table of contents pages - like <a href="TableOfContents.asp" title="Example Table of Contents">this one</a>), and is
able to create both client-side <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.JavaScriptSearchEngine.asp" title="JavaScript Search Engine">JavaScript Search Engines</a> and server-side <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.ASPSearchEngine.asp" title="JavaScript Search Engine">ASP Search Engines</a> for a website.</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ASPAlliance/default.htm"><img
src="images/Icon_HTML.gif" width="16" height="16" alt="View Sample Output (HTML Format)"
align="absmiddle" border="0"></a> <a
href="http://www.winnershtriangle.com/w/TheWebsiteUtility/Reports/ASPAlliance/default.htm"
target="_blank" title="View Sample Output (HTML Format)">View Sample Output</a> (HTML Format).<br>
<a
href="http://www.brettb.com/redirector.asp?URL=downloads/TheWebsiteUtilityTrial.zip"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version"
border="0" align="absmiddle"></a> <a
href="http://www.brettb.com/redirector.asp?URL=downloads/TheWebsiteUtilityTrial.zip" title="Download Trial Version">Download
Trial Version</a> (3Mb ZIP file).</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" valign="top"><a
href="http://www.regnow.com/softsell/nph-softsell.cgi?item=8452-18&affiliate=44172" target="_blank" title="Text Workbench"><strong>Text Workbench</strong></a></td>
</tr>
<tr>
<td width="100%" valign="top">Text Workbench is a file search and replacement utility for text files and Microsoft Office documents. Make rapid file replacements on multiple files and folders full of files. Advanced replacement options include regular expressions support. It even works on remote file systems via FTP. A Regular Expression Laboratory allows advanced pattern matching and replacement expressions to be built and tested. This great utility will make your everyday development tasks much easier!
</td>
</tr>
<tr>
<td width="100%" valign="top">
<a
href="http://www.regnow.com/trialware/download/Download_TxtWrBSetup.exe?item=8452-18&affiliate=44172"><img
src="images/Icon_Download.gif" width="18" height="20" alt="Download Trial Version of Text Workbench"
border="0" align="absmiddle"></a> <a
href="http://www.regnow.com/trialware/download/Download_TxtWrBSetup.exe?item=8452-18&affiliate=44172" title="Download Trial Version of Text Workbench">Download
Trial Version</a> (3Mb ZIP file; you have the option to either install directly from this link or save the file for later installation).</td>
</tr>
</table>
</div>
<h2>Author details</h2>
<p><p><a href="http://www.brettb.com/" title="View Brett's personal website">Brett Burridge</a>
spent two years working in the <a href="http://www.essex.ac.uk/"
title="University of Essex">University of Essex</a> Computing Service, before moving to <a
href="http://www.intapps.com/" title="The Internet Applications Group">The Internet
Applications Group</a> in the Autumn of 1999, where he developed e-Business applications for a range of
corporate clients and dot-com start ups.</P>
<P>Brett is presently employed as an Internet developer and technical writer
through his own company,
<a href="http://www.winnershtriangle.com/w/Default.asp" title="Winnersh Triangle Web Solutions Limited" target="_blank">Winnersh Triangle Web Solutions Limited</a>.
The company produces a number of
innovative products, including the popular
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank" title="ASP Documentation Tool™ - creates project documentation for ASP 2.0 and 3.0 websites written in VBScript and JScript, and also SQL Server 2000 databases">ASP Documentation Tool™</a>, the <a href="http://www.winnershtriangle.com/w/Products.IndexServerCompanion.asp" target="_blank" title="Index Server Companion - extends the functionality of Index Server to allow indexing of content from remote websites and ODBC databases">Index Server Companion</a>, the <a href="http://www.winnershtriangle.com/w/Products.ASPNETDocumentationTool.asp" target="_blank" title="ASP.NET Documentation Tool - creates documentation for ASP.NET web applications written in VB.NET and C#">ASP.NET Documentation Tool</a>, the <a href="http://www.winnershtriangle.com/w/Products.SQLServerDocumentationTool.asp" target="_blank" title="SQL Server Documentation Tool - Documents Microsoft SQL Server Databases">SQL Server Documentation Tool</a> and <a href="http://www.winnershtriangle.com/w/Products.TheWebsiteUtility.asp" target="_blank" title="The Website Utility">The Website Utility</a>.
The company is also available for <a href="http://www.winnershtriangle.com/w/Services.Main.asp" target="_blank" title="web application design and development">web application design and development</a> at reasonable rates, primarily using
<a href="http://www.winnershtriangle.com/w/Services.Microsoft.asp" target="_blank" title="Development using Microsoft technologies such as ASP, ASP.NET, Visual Basic, SQL Server">Microsoft technologies</a> (ASP, ASP.NET, Visual Basic, SQL Server) but also using <a href="http://www.winnershtriangle.com/w/Services.OpenSource.asp" target="_blank" title="Open source development using technologies such as PHP, MySQL and Perl">open source</a>
technologies such as PHP, MySQL and Perl. Specialist services include development
of <a href="http://www.winnershtriangle.com/w/Services.IndexServer.asp" target="_blank" title="Development of search solutions using Microsoft's Index Server and Site Server 3.0 Search">search solutions</a> using Microsoft's Index Server and Site Server 3.0 Search.
</P>
<P>
As well as the ASPAlliance, Brett has written articles for <a href="http://www.ariadne.ac.uk/issue33/nt-explorer/" title="Read Brett's most recent article for Ariadne.ac.uk" target="_blank">Ariadne.ac.uk</a>
and <a href="http://www.asptoday.com/content.asp?id=1435" target="_blank" title="Read Brett's first ASPToday article">ASPToday</a>, and has contributed recipes to the <a href="http://www.amazon.com/exec/obidos/ASIN/0672325241/brettbcom" target="_blank" title="ASP.NET Developer's Cookbook">ASP.NET Developer's Cookbook</a>.
<small><a href="Links.asp" style="color: rgb(252,253,253);">links</a></small>
</P>
<p>
Outside web development, Brett is interested in digital photography (here's my <a href="http://www.brettb.com/gallery.asp" target="_blank" title="My digital photo gallery">photo gallery</a>), <a href="http://www.brettb.com/MyTropicalFishtank.asp" target="_blank" title="My Tropical Fish!">tropical fishkeeping</a>
and collecting contemporary works of art by artists such as <a href="http://www.brettb.com/Doug_Hyde_Gallery.asp" title="My Doug Hyde Limited Edition Sculptures and Prints" target="_blank">Doug Hyde</a>.
</p>
<p>Contact Brett by emailing <script language="JavaScript"><!--
document.write('<a title="Email Brett" href="mailto:' + 'brett' + '@asp' + 'alliance.com">brett' + '@' + 'aspalliance.com</a>');
// --></script></p>
<p align="center">
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp?FROM=http://authors.aspalliance.com/brettb/EasyADORecordSetPaging.asp" target="_blank"><IMG SRC="images/ASPDocumentationToolBannerAd.gif" width="468" height="60" alt="Download a free ASP Documentation Tool now!!!" border="0"></a>
</p>
</p>
<h2>Article history</h2>
<p>"Easy ADO Recordset paging" originally published on ASPWatch.com on October
26 2000. Republished on ASPAlliance.com on 28 September 2001.</p>
<p><a href="Default.asp" title="Back to the ASP Kitchen">ASP Kitchen</a>: <a
href="ASPWatchArticles.asp" title="Back to the ASPWatch.com articles">ASPWatch.com
articles</a>: Easy ADO RecordSet Paging</p>
</td>
</td>
<td valign="top" align="center" bgcolor="#CCCCCC" style="BORDER-LEFT: rgb(102,102,102) 1px solid;"> <script type="text/javascript"><!--
google_ad_client = "pub-7044749527879330";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_channel ="5708954406";
google_color_border = "0000C0";
google_color_bg = "FFFFFF";
google_color_link = "E60000";
google_color_url = "0000FF";
google_color_text = "000000";
google_ad_type = "text_image";
google_alternate_ad_url = "http://authors.aspalliance.com/brettb/NoGoogleAds.asp";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<p align="center">
<a href="http://www.winnershtriangle.com/w/Products.ASPDocumentationTool.asp" target="_blank"><img src="http://authors.aspalliance.com/brettb/images/ASPDocumentationTool_1.gif" alt="Download a Free ASP Documentation Tool Now!"></a>
</p>
<!-- Search Google -->
<center>
<form method="get" action="http://www.google.com/custom" target="google_window">
<table bgcolor="#cccccc">
<tr><td nowrap="nowrap" valign="top" align="left" height="32">
<a href="http://www.google.com/">
<img src="http://www.google.com/logos/Logo_25gry.gif" border="0" alt="Google" align="middle"></img></a>
<br/>
<input type="text" name="q" size="15" maxlength="255" value=""></input>
</td></tr>
<tr><td valign="top" align="left">
<input type="submit" name="sa" value="Search"></input>
<input type="hidden" name="client" value="pub-7044749527879330"></input>
<input type="hidden" name="forid" value="1"></input>
<input type="hidden" name="channel" value="4628523158"></input>
<input type="hidden" name="ie" value="ISO-8859-1"></input>
<input type="hidden" name="oe" value="ISO-8859-1"></input>
<input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#336699;VLC:663399;AH:center;BGC:FFFFFF;LBGC:336699;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:1;"></input>
<input type="hidden" name="hl" value="en"></input>
</td></tr></table>
</form>
</center>
<!-- Search Google -->
<p align="center">
<a href="http://www.regnow.com/softsell/visitor.cgi?affiliate=44172&action=site&vendor=7522" target="_blank" title="Search Engine Builder - Build a search engine for your website!"><img border="0" src="images/SearchEngineBuilder.gif" alt="Search Engine Builder - Build a search engine for your website!"></a>
</p>
</td>
</tr>
<tr><td bgcolor="#CC0000" colspan="2" style="BORDER-TOP: rgb(102,102,102) 1px solid;"><small><font color="white">© page content copyright Brett Burridge 1998 - 2004.</font></small></td></tr>
</table>
<!--End ASPAlliance Document Article-->
</body>
</html>