Hey There,
Try something like this:
Repeat additional page code below to cover the query output. You can
add enough additional page code to account for future output data. Like
if current output requires 5 pages, you could code for 8 pages, giving you
a 3 page buffer before having to add more additional page code.
Leonard B
<=== Code below ===>
<cfdocument>
<table>
<tbody>
<cfoutput query="qname" maxrows="[enter max rows to display per page]" startrow="1">
<tr>
<td>
<!--- Insert output --->
</td>
</tr>
</cfoutput>
</tbody>
</table>
<!--- Additional page (2) --->
<cfif qname.recordcount gt 25>
<cfdocumentitem type="pagebreak" />
<table>
<tbody>
<cfoutput query="qname" maxrows="[enter max rows to display per page]" startrow="[enter start row for page]">
<tr>
<td>
<!--- Insert output --->
</td>
</tr>
</cfoutput>
</tbody>
</table>
</cfif>
<!--- Additional page (3) --->
<cfif qname.recordcount gt 50>
<cfdocumentitem type="pagebreak" />
<table>
<tbody>
<cfoutput query="qname" maxrows="[enter max rows to display per page]" startrow="[enter start row for page]">
<tr>
<td>
<!--- Insert output --->
</td>
</tr>
</cfoutput>
</tbody>
</table>
</cfif>
</cfdocument>
AdChoices