User Guide

cfquery 285

State

</td>

</tr>

<!---- Output the query and define the startrow and maxrows parameters.

Use the query variable CurrentCount to keep track of the row you

are displaying. ------>

<cfoutput

query="GetParks" startrow="#StartRow#" maxrows="#MaxRows#">

<tr>

#GetParks.CurrentRow#

</td>

#ParkName#

</td>

#Region#

</td>

#State#

</td>

</tr>

</cfoutput>

<!----- If the total number of records is less than or equal

to the total number of rows, then offer a link to

the same page, with the startrow value incremented by

maxrows (in the case of this example, incremented by 10) --------->

<tr>

<a href="index.cfm?startrow=

<cfoutput> #Evaluate(StartRow + MaxRows)#</cfoutput>

">See next <cfoutput>#MaxRows#</cfoutput> rows</a>

</cfif>

</td>

</tr>

</table>