CreateTimeSpan
543
cachedWithin = "#
CreateTimeSpan(0, 6, 0, 0)
#">
SELECT PARKNAME, REGION, STATE
FROM Parks
ORDER by ParkName, State
</cfquery>
</cfoutput>
<!--- 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 (St MaxRows) LTE GetParks.RecordCount>
<a href = "cfquery.cfm?startrow = <cfoutput>#St MaxRows#
</cfoutput>">See next <cfoutput>#MaxRows#</cfoutput> rows</A>
</cfif>
</TD>
</TR>
</TABLE>
Summary of Contents for COLFUSION MX 7-CFML
Page 1: ...COLDFUSION MX7 CFML Reference...
Page 20: ...20 Chapter 1 Reserved Words and Variables...
Page 50: ...50 Chapter 2 ColdFusion Tags cfelse br Searching cfif cfloop cfif...
Page 101: ...cfdefaultcase 101 cfdefaultcase cfswitch cfoutput Your grade is grade cfoutput...
Page 115: ...cfdocumentsection 115 cfdocumentsection cfoutput cfdocument...
Page 411: ...cftable 411 cftable body html...
Page 515: ...Chr 515 maxlength 5 p input type Submit name input type RESET cfform...
Page 605: ...GetEncoding 605 WriteOutput The encoding is theEncoding cfscript cfif...
Page 629: ...GetProfileString 629 tr td input type Submit name Submit value Submit td td td tr table form...
Page 655: ...IIf 655 cfoutput IIf Hour Now GTE 12 DE It is afternoon or evening DE It is morning cfoutput b...
Page 664: ...664 Chapter 3 ColdFusion Functions cfelse h3 Conversion error h3 cfif...
Page 687: ...IsStruct 687 cfoutput cfquery cfif cfoutput hr Employee Add Complete cfoutput cfcase cfswitch...
Page 751: ...LSDateFormat 751 hr noshade cfoutput cfloop...
Page 861: ...StructFind 861 cfquery cfif cfoutput hr Employee Add Complete cfoutput cfcase cfswitch...
Page 903: ...Val 903 value Is the beginning numeric name form...
Page 932: ...932 Chapter 3 ColdFusion Functions...
Page 944: ...944 Chapter 4 ColdFusion MX Flash Form Style Reference...
Page 962: ...962 Chapter 5 Application CFC Reference...
Page 1054: ...1054 Chapter 6 ColdFusion MX Event Gateway Reference...