I am not sure this is the most efficient way to do this, but I pass the form
values, if any, in the url of the pager, then at the top of the results
page, I convert the url variable to a form variable ( which may be
unneccessary, but I steer clear of unscoped variables)
<cfif isdefined("url.someVar")>
<cfset form.someVar = url.someVar>
</cfif>
hth, and again, there may be/always are better solutions....
Charles Hanlon
Senior Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com
The People. The Platform. The Products.
Make the Difference
----- Original Message -----
From: "Alan Dunn" <[EMAIL PROTECTED]>
To: "CF-Talk" <cf-talk@houseoffusion.com>
Sent: Wednesday, July 19, 2006 12:00 PM
Subject: Form Variables and Find N Next
> I've got a 2 field search form that submits to a results page that
> displays
> 20 records at a time, but when I click on the next 20 results, I get the
> error saying "Element CATEGORYNAME is undefined in FORM."
>
> Here's my query-- I don't *think* its my problem, but just to make sure:
>
> <cfquery name="CustomerSearch" datasource="#APPLICATION.DataSource#">
> SELECT CategoryName, CustomerID, CustomerName
> FROM Customers, Categories
> WHERE 0=0
> <!---Check to category field is blank:--->
> <cfif FORM.CategoryName IS NOT "">
> AND CategoryName = '#FORM.CategoryName#'
> </cfif>
> <!---Check to see if CustomerDesc Search is blank:--->
> <cfif FORM.CustomerDesc IS NOT "">
> AND CustomerDesc LIKE '%#FORM.CustomerDesc#%'
> </cfif>
> ORDER BY CategoryName
> </cfquery>
>
> how do I keep my form variables available for the next set of records?
> <cfparam>? Session scopes? My head is full of CFWACK and I think I may be
> guilty of new developer over complication, but I can't seem to make this
> work. Any hints or help from people that know more than I do would be
> greatly appreciated.
>
> Thanks :)
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247062
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
