I used your url string for the heck of it and dumped it just fine here, maybe check the datatype for that field in the db just to verify that's what it is expecting?
Bob -----Original Message----- From: Yogendra Shivhare [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 1:31 PM To: CF-Newbie Subject: Re: Error in url parameter Bob, Thanks for the reply. I tried it but it didn't work >Not sure if this is it but in your url string you have Form_id and in >the sproc you have Form_ID? > >Bob > >I am getting following error in my applicationElement FORM_ID is >undefined in URL. >G:\ITO_Services_Webs\iForms\sessionMgmt.cfm: line 103 >101 : <cfquery name="Get_Form" datasource="#iForms_DSN#"> >102 : EXEC SP_Get_Form 1 >103 : @Form_ID = #URL.FORM_ID#, >104 : @Key_Type = '#URL.Key_Type#', >105 : @Key_ID = #URL.Key_ID# >Form id is always there in url when one try to access the site. Link is >http://iforms.sbc.com/iforms_loader.cfm?Form_id=67&Key_Type=VPMO_ID&Key_ >ID=71241&SBCUID=dw4694&IO_Mode=1&uiid=86972628 > >Here is the stack trace: >"Error","jrpp-722","06/04/08","10:12:47","iForms","Element FORM_ID is >undefined in URL. The specific sequence of files included or processed >is: G:\ITO_Services_Webs\iForms\parser.cfm " >coldfusion.runtime.UndefinedElementException: Element FORM_ID is >undefined in URL. at >coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1054) >at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1031) at >coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:113 >0) at >cfsessionMgmt2ecfm41580940.runPage(G:\ITO_Services_Webs\iForms\sessionMg >mt.cfm:103) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) >at >coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.j >ava:63) at >coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255) at >coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1918) at >cfparser2ecfm1959136383.runPage(G:\ITO_Services_Webs\iForms\parser.cfm:2 >5) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at cold! > fusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343) at >coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at >coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) >at >coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: >51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at >coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50) at >coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) >at >coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist >enceFilter.java:28) at >coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at >coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at >coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at >coldfusion.CfmServlet.service(CfmServlet.java:105) at >coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) >at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at >com.seefusion.F! > ilter.doFilter(Filter.java:49) at >com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at >jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at >jrun.servlet.FilterChain.service(FilterChain.java:101) at >jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at >jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at >jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257 >) at >jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527 >) at >jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: >204) at >jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j >ava:349) at >jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java >:457) at >jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav >a:295) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > >I am new to cold fusion and would appreciate any help you can provide. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3707 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
