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:3988 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
