Lewis...
How many years of data do you have?
A few things come to mind.. You could have separate queries for each year...
(clumsy but effective) Or tie a cfDiv to your query - based on year passed to
the div...
The page...
<cfform>
<cfinput type="text" name="MyYear" value="#FORM. MyYear#" />
</cfform>
<h3>Results </h3>
<cfdiv bind="url:MyResultsTable.cfm? MyYear ={MyYear}" bindonload="true" />
---
The Query... OnMy ResultsTable.cfm...
SELECT Data
FROM Table
WHERE Year = <cfqueryparam value="#URL.MyYear#">
This isn't final code - but it should help... Additionally - you could have
the cfinput be a select - with Year drop down... looping from "this year" to
earliest year...
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:6078
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
