In your form statement you have two increments of data. Param[counter]Criteria param[counter]Status
If these are the only 2 elements that are passed in the form, then your code referecing: ( Form['param#iCounter#Type'] Form["param#iCounter#String"] Form['param#iCounter#DealerStatus'] Form["param#iCounter#Metric"] ) Will fail miserably. You 'can' add a loop at the top of the page that 'defaults' all of these parameters so that they exist: <cfloop index="iCounter" from="0" to="#(iParamCount - 1)#"> <cfparam name="param#iCounter#Type" default=""> <cfparam name="param#iCounter#String" default=""> <cfparam name="param#iCounter#DealerStatus" default=""> <cfparam name="param#iCounter#Metric" default=""> </cfloop> HOWEVER, since you are new to the code and not sure why this page is doing what it is doing, I would suggest trying to figure out if the sending form page is broken rather than the processing page, first. You could just make a page that breaks, work, but then create bigger and worse issues. William ::-----Original Message----- ::From: Spencer Liddle [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, September 16, 2008 2:54 PM ::To: CF-Newbie ::Subject: Element ... is undefined in a Java object of type class ::coldfusion.filter.FormScope... :: ::Ahoy! :: ::I am pulling my hair out right now. Long story short I am a graphic ::designer with a little bit of background in web programing - mainly Action ::Script 3 - that got thrown into hellfire when the SQLi attacks went around ::last month. As the only person in the building who knew something about ::"web-stuff" I was tasked with fixing the site and restoring order. 3,000 ::query fixes later I have a new task of fixing the other bugs in the site ::because I fixed the SQLi. :: ::Now that you know me lets get down to business. :: :: ::----ERROR CODE---- :: ::Error Occurred While Processing Request ::Element param0DealerStatus is undefined in a Java object of type class ::coldfusion.filter.FormScope referenced as :: :: ::The error occurred in F:\Inetpub\wwwroot\cm_search_companies_query.cfm: ::line 59 ::Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 56 ::Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 25 ::Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 6 ::Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 1 ::Called from F:\Inetpub\wwwroot\cm_view_companies.cfm: line 530 ::Called from F:\Inetpub\wwwroot\cm_view_companies.cfm: line 1 :: ::57 : ::58 : <cfcase value="dealer_status"> ::59 : <cfswitch ::expression="#Form['param#iCounter#DealerStatus']#"> ::60 : <cfcase value="current"> ::61 : <cfset iStandardParamCount = ::iStandardParamCount + 1> :: ::----ERROR CODE---- :: ::This error happens when I try and pull up a list of statuses for ::dealers(old, new, current, etc.). This is the code it is referencing. The ::code that comes before the section about dealers (with the *) works great. :: ::CFDUMP: http://img398.imageshack.us/my.php?image=72638379pe7.jpg :: ::----Page Code---- :: ::<cfloop index="iCounter" from="0" to="#(iParamCount - 1)#"> ::<cfswitch expression="#Form["param#iCounter#Criteria"]#"> :: ::*<cfcase value="company_name"> ::*<cfswitch expression="#Form['param#iCounter#Type']#"> ::*<cfcase value="starts_with"> ::*<cfset iStandardParamCount = iStandardParamCount + 1> ::*<cfset sStandardParam[iStandardParamCount] = "tblCompanies.Name LIKE '" & ::*Replace(Form["param#iCounter#String"], "'", "''", "all") & "%'"> ::*</cfcase> :: ::*<cfcase value="contains"> ::*<cfset iStandardParamCount = iStandardParamCount + 1> ::*<cfset sStandardParam[iStandardParamCount] = "tblCompanies.Name LIKE '%" ::& *Replace(Form["param#iCounter#String"], "'", "''", "all") & "%'"> ::*</cfcase> :: ::*<cfcase value="is_blank"> ::*<cfset iStandardParamCount = iStandardParamCount + 1> ::*<cfset sStandardParam[iStandardParamCount] = "tblCompanies.Name = ''"> ::*</cfcase> :: ::*<cfcase value="is_duplicated"> ::*<cfset iCharacters = getValueOf(Form["param#iCounter#Characters"])> :: ::*<cfif bAnd> ::*<cfset iCondensedGroupParamCount = iCondensedGroupParamCount + 1> ::*<cfset sCondensedGroupParam[iCondensedGroupParamCount] = ::"LEFT(tblCompanies.Name, *#iCharacters#)"> ::*<cfelse> ::*<cfset iStandardParamCount = iStandardParamCount + 1> ::*<cfset sStandardParam[iStandardParamCount] = "LEFT(tblCompanies.Name, ::*#iCharacters#) IN (SELECT LEFT(Name, #iCharacters#) FROM tblCompanies ::GROUP BY *LEFT(Name, #iCharacters#) HAVING COUNT(ID) > 1)"> ::*</cfif> ::*</cfcase> ::*</cfswitch> ::*</cfcase> :: ::<cfcase value="dealer_status"> ::<cfswitch expression="#Form['param#iCounter#DealerStatus']#"> ::<cfcase value="current"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "tblCompanies.IsDealer = 1"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "tblCompanies.IsDealer = 0"> ::</cfif> ::</cfcase> :: ::<cfcase value="new"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::AND DATEADD(day, 30, tblCompanies.DealerStatusTimestamp) >= GETDATE())"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::AND (tblCompanies.DealerStatusTimestamp <= DATEADD(day, -30, GETDATE()) OR ::tblCompanies.DealerStatusTimestamp IS NULL))"> ::</cfif> ::</cfcase> :: ::<cfcase value="current_recert"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::AND tblCompanies.IsRecertified = 1)"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::AND (tblCompanies.IsRecertified != 1 OR tblCompanies.IsRecertified IS ::NULL))"> ::</cfif> ::</cfcase> :: ::<cfcase value="former"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "tblCompanies.WasDealer = 1"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.WasDealer != 1 ::OR tblCompanies.WasDealer IS NULL)"> ::</cfif> ::</cfcase> :: ::<cfcase value="current_or_former"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::OR tblCompanies.WasDealer = 1)"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 0 ::OR tblCompanies.WasDealer = 0)"> ::</cfif> ::</cfcase> :: ::<cfcase value="unverified"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "((tblCompanies.IsDealer = 1 ::OR tblCompanies.WasDealer = 1) AND tblCompanies.IsNew = 1)"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::OR tblCompanies.WasDealer = 1)"> ::</cfif> ::</cfcase> :: ::<cfcase value="requesting"> ::<cfset bReqDealerStatus = True> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 0 ::AND tblCompanies.IsNew = 0 AND tblCompanies.ID IN (SELECT CompanyID FROM ::tblPeople WHERE WantsDealerStatus = 1 AND CompanyID IS NOT NULL))"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 0 ::AND tblCompanies.IsNew = 0 AND tblCompanies.ID IN (SELECT CompanyID FROM ::tblPeople WHERE WantsDealerStatus = 0 AND CompanyID IS NOT NULL))"> ::</cfif> ::</cfcase> :: ::<cfcase value="not"> ::<cfset iStandardParamCount = iStandardParamCount + 1> ::<cfif Form["param#iCounter#Metric"] EQ "is"> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 0 ::AND tblCompanies.WasDealer = 0)"> ::<cfelse> ::<cfset sStandardParam[iStandardParamCount] = "(tblCompanies.IsDealer = 1 ::OR tblCompanies.WasDealer = 1)"> ::</cfif> ::</cfcase> ::</cfswitch> ::</cfcase> :: ::----Display Code---- ::This is one example of what is pulled from the above loop. :: ::function dealers_without_logins() ::{ ::var sOutput = ''; :: ::sOutput += '<form name="toolsForm" method="post" ::action="cm_view_companies.cfm"> '; ::sOutput += '<input type="hidden" name="search" value="1"> '; ::sOutput += '<input type="hidden" name="logic" value="bool_and"> '; ::sOutput += '<input type="hidden" name="paramCount" value="2"> '; ::sOutput += '<input type="hidden" name="param0Criteria" ::value="dealer_status"> '; ::sOutput += '<input type="hidden" name="param0Status" value="current"> '; ::sOutput += '<input type="hidden" name="param1Criteria" value="user_count"> ::'; ::sOutput += '<input type="hidden" name="param1Status" value="zero"> '; ::sOutput += '</form>'; :: ::obj('dynamicForm').innerHTML = sOutput; :: ::document.toolsForm.submit(); ::} :: ::I am pulling my hair out. T_T :: ::Thank You, :: ::Spencer :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:4000 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
