No Dice. If my loop starts at 1 the page never loads and just goes over and
over(turned off time limit to see if it would end.) Where if my loop starts at
0 I get these two errors.
--One--
Element param0Metric 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 108
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 104
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 57
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 26
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 7
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
106 : <cfcase value="unverified">
107 : <cfset iStandardParamCount =
iStandardParamCount + 1>
108 : <cfif
Form["param#iCounter#Metric"] EQ "is">
109 : <cfset
sStandardParam[iStandardParamCount] = "((tblCompanies.IsDealer = 1 OR
tblCompanies.WasDealer = 1) AND tblCompanies.IsNew = 1)">
110 : <cfelse>
--------------------------------------------------------------------------------
Please try the following:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Stack Trace (click to expand)
at
cfcm_search_companies_query2ecfm1420285873._factor6(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:108)
at
cfcm_search_companies_query2ecfm1420285873._factor20(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:104)
at
cfcm_search_companies_query2ecfm1420285873._factor39(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:57)
at
cfcm_search_companies_query2ecfm1420285873._factor40(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:26)
at
cfcm_search_companies_query2ecfm1420285873._factor45(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:7)
at
cfcm_search_companies_query2ecfm1420285873.runPage(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:1)
at
cfcm_view_companies2ecfm1551341189._factor17(F:\Inetpub\wwwroot\cm_view_companies.cfm:530)
at
cfcm_view_companies2ecfm1551341189.runPage(F:\Inetpub\wwwroot\cm_view_companies.cfm:1)
coldfusion.runtime.UndefinedElementException: Element param0Metric is undefined
in a Java object of type class coldfusion.filter.FormScope referenced as
at coldfusion.runtime.CfJspPage.ArrayGetAt(CfJspPage.java:505)
at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:511)
at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:397)
at
cfcm_search_companies_query2ecfm1420285873._factor6(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:108)
at
cfcm_search_companies_query2ecfm1420285873._factor20(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:104)
at
cfcm_search_companies_query2ecfm1420285873._factor39(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:57)
at
cfcm_search_companies_query2ecfm1420285873._factor40(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:26)
at
cfcm_search_companies_query2ecfm1420285873._factor45(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:7)
at
cfcm_search_companies_query2ecfm1420285873.runPage(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876)
at
cfcm_view_companies2ecfm1551341189._factor17(F:\Inetpub\wwwroot\cm_view_companies.cfm:530)
at
cfcm_view_companies2ecfm1551341189.runPage(F:\Inetpub\wwwroot\cm_view_companies.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
--Two--
Element param0Status 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 60
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 57
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 26
Called from F:\Inetpub\wwwroot\cm_search_companies_query.cfm: line 7
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
58 :
59 : <cfcase value="dealer_status">
60 : <cfswitch
expression="#Form['param#iCounter#Status']#">
61 : <cfcase value="current">
62 : <cfset iStandardParamCount =
iStandardParamCount + 1>
--------------------------------------------------------------------------------
Please try the following:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Stack Trace (click to expand)
at
cfcm_search_companies_query2ecfm1420285873._factor20(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:60)
at
cfcm_search_companies_query2ecfm1420285873._factor39(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:57)
at
cfcm_search_companies_query2ecfm1420285873._factor40(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:26)
at
cfcm_search_companies_query2ecfm1420285873._factor45(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:7)
at
cfcm_search_companies_query2ecfm1420285873.runPage(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:1)
at
cfcm_view_companies2ecfm1551341189._factor17(F:\Inetpub\wwwroot\cm_view_companies.cfm:530)
at
cfcm_view_companies2ecfm1551341189.runPage(F:\Inetpub\wwwroot\cm_view_companies.cfm:1)
coldfusion.runtime.UndefinedElementException: Element param0Status is undefined
in a Java object of type class coldfusion.filter.FormScope referenced as
at coldfusion.runtime.CfJspPage.ArrayGetAt(CfJspPage.java:505)
at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:511)
at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:397)
at
cfcm_search_companies_query2ecfm1420285873._factor20(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:60)
at
cfcm_search_companies_query2ecfm1420285873._factor39(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:57)
at
cfcm_search_companies_query2ecfm1420285873._factor40(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:26)
at
cfcm_search_companies_query2ecfm1420285873._factor45(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:7)
at
cfcm_search_companies_query2ecfm1420285873.runPage(F:\Inetpub\wwwroot\cm_search_companies_query.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876)
at
cfcm_view_companies2ecfm1551341189._factor17(F:\Inetpub\wwwroot\cm_view_companies.cfm:530)
at
cfcm_view_companies2ecfm1551341189.runPage(F:\Inetpub\wwwroot\cm_view_companies.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Thanks,
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:3997
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15