User Guide

CreateTimeSpan 437
<!--- build HTML table to display query --->
<table cellpadding = 1 cellspacing = 1>
<TR>
<TD colspan = 2 bgcolor = f0f0f0>
<b><I>Park Name</i></b>
</TD>
<TD bgcolor = f0f0f0>
<b><i>Region</i></b>
</TD>
<TD bgcolor = f0f0f0>
<b><i>State</i></b>
</TD>
</TR>
<!--- Output query, define startrow and maxrows. Use query variable
CurrentCount to
track the row you are displaying. --->
<cfoutput query = "GetParks" StartRow = "#StartRow#"
maxrows = "#maxrows#">
<TR>
<TD valign = top bgcolor = ffffed>
<b>#GetParks.CurrentRow#</b>
</TD>
<TD valign = top>
<font size = "-1">#ParkName#</font>
</TD>
<TD valign = top>
<font size = "-1">#Region#</font>
</TD>
<TD valign = top>
<font size = "-1">#State#</font>
</TD>
</TR>
</cfoutput>
<!--- If number of records is less than or equal to number of rows, offer link
to
same page, with startrow value incremented by maxrows (in this example,
incremented by 10) --->
<TR>
<TD colspan = 4>
<cfif (StartRow + MaxRows) LTE GetParks.RecordCount>
<a href = "cfquery.cfm?startrow = <cfoutput>
#Evaluate(StartRow + MaxRows)#</cfoutput>">
See next <cfoutput>#MaxRows#</cfoutput> rows</A>
</cfif>
</TD>
</TR>
</TABLE>