Ive 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."
Heres my query-- I dont *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:247060 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
