Hello, I am working through some tutorials, trying to make my self smarter in
dynamic application building. The problem I am having (and I think I have
followed the instructions clearly) is when I try to setup dynamic data sorts,
all the code seems to check out, but when I go to test it in a web browser or
live data view, it doesn?t do anything. Below is the bindings & code, can
someone help me and see if maybe I?ve done something wrong? Thanks Jeremy
-------------------------------------- Recordset (parkQuery) PARKNAME
CITY STATE REGION PARKTYPE CFParam URL.STATE URL.SORT
---------------------------------------

<cfparam name="URL.STATE" default="1"><cfparam name="URL.SORT" default="STATE">
<cfquery name="parkQuery" datasource="exampleapps">
SELECT PARKNAME, CITY, "STATE", REGION, PARKTYPE
FROM tblParks
WHERE "STATE" = '#URL.STATE#'
ORDER BY '#URL.SORT#' ASC</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html><!-- InstanceBegin template="/Templates/bookexamples.dwt.cfm"
codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
</head>

<body>
<!-- InstanceBeginEditable name="Title" -->Display Park States<!--
InstanceEndEditable -->
<p>&nbsp;</p>
<p>&nbsp;</p>
<!-- InstanceBeginEditable name="Body" -->
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><a
href="displayParksState.cfm?STATE=<cfoutput>#URL.S TATE#</cfoutput>&SORT=PARKNAME
" target="_self">PARK NAME</a></div></td>
<td><div align="center"><a
href="displayParksState.cfm?STATE=<cfoutput>#URL.S TATE#</cfoutput>&SORT=CITY"
target="_self">CITY</a></div></td>
<td><div align="center"><a
href="displayParksState.cfm?STATE=<cfoutput>#URL.S TATE#</cfoutput>&SORT=STATE"
target="_self">STATE</a></div></td>
<td><div align="center"><a
href="displayParksState.cfm?STATE=<cfoutput>#URL.S TATE#</cfoutput>&SORT=REGION"
target="_self">REGION</a></div></td>
<td><div align="center"><a
href="displayParksState.cfm?STATE=<cfoutput>#URL.S TATE#</cfoutput>&SORT=PARKTYPE
" target="_self">PARK TYPE</a></div></td>
</tr>
<cfset varTemp = "true">
<cfoutput query="parkQuery">
<cfif varTemp EQ "true">
<cfset backColor = "##FFFFFF">
<cfset varTemp = "false">
<cfelse>
<cfset backColor = "##CCCCCC">
<cfset varTemp = "true">
</cfif>
<tr bgcolor = "#backColor#">
<td>#parkQuery.PARKNAME#</td>
<td>#parkQuery.CITY#</td>
<td>#parkQuery.STATE#</td>
<td>#parkQuery.REGION#</td>
<td>#parkQuery.PARKTYPE#</td>
</tr>
</cfoutput>
</table>
<!-- InstanceEndEditable -->
</body>
<!-- InstanceEnd --></html>
TextRecordset (parkQuery)