>- see footer for list info -< Without delving deeper, if you get an error like:
Element RECORDCOUNT is undefined in RES_APPM8_GET_CLIENT_DETAILS_QUERY. It means that RES_APPM8_GET_CLIENT_DETAILS_QUERY is unlikely to be a query. Output #IsQuery(RES_APPM8_GET_CLIENT_DETAILS_QUERY)# before attemping to use it, what do you get? Adrian On 24 August 2010 09:46, <[email protected]> wrote: > >- see footer for list info -< > BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }Hi > All, > I have a service which I have raised an issue with before but the > situation solved itself with no involvement from me. However, the > issue has come back today (with nothing having changed from a code > perspective for no reason). > On arrival at any page in the site, I perform a DB check against the > URL to see which client is accessing the system as each client has an > individual URL. > The system performs a stored procedure (storedproc) check and if it > only finds a single result it sets a number of variables and allows > the client to proceed. > Currently the query is not returning any information and returning > this error saying the record count cannot be found in the query. Here > is the code segment below. > I also have another page at > http://www.appointmentm8.com/samplescripts/test/storedProc.cfm [1] > which also runs 3 different queries which should return the same > result. I have a normal SQL statement which runs the query in native > SQL, I have a normal query which calls the stored procedure through > an EXEC statement and then I have an storeproc version. At the > moment the exec and storedproc are working as expected but the query > one does not. If I copy and paste the code onto the other page it > stops working. > As mentioned this is a problem that comes and goes but is now > causing a massive issue. Any help you can provide would be > appreciated. I have enabled all debugging options as Classic so it > will be at the bottom of the page, will turn it off again once I have > it sorted. > Page is at http://www.appointmentm8.com/ecc [2] > coldfusion.runtime.UndefinedElementException: Element RECORDCOUNT is > undefined in RES_APPM8_GET_CLIENT_DETAILS. > at > coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1061) > at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1016) > at > coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1123) > at > > cfmyGlobals2ecfm2066296310.runPage(D:wwwroot_CFMX10120appointmentm8.comwwwrootmyGlobals.cfm:80) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) > at > > cfGlobals2ecfm1858778854.runPage(D:wwwroot_CFMX10120appointmentm8.comwwwrootpluginsGlobals.cfm:13) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) > at > > cfc_general2ehome2ecfm2003142446._factor27(D:wwwroot_CFMX10120appointmentm8.comwwwrootparsedc_general.home.cfm:8) > at > > cfc_general2ehome2ecfm2003142446.runPage(D:wwwroot_CFMX10120appointmentm8.comwwwrootparsedc_general.home.cfm:1) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) > at > > cffusebox42eruntime2ecfmx2ecfm818337901._factor15(D:wwwroot_CFMX10120appointmentm8.comwwwrootfusebox4.runtime.cfmx.cfm:433) > at > > cffusebox42eruntime2ecfmx2ecfm818337901._factor17(D:wwwroot_CFMX10120appointmentm8.comwwwrootfusebox4.runtime.cfmx.cfm:426) > at > > cffusebox42eruntime2ecfmx2ecfm818337901.runPage(D:wwwroot_CFMX10120appointmentm8.comwwwrootfusebox4.runtime.cfmx.cfm:1) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) > at > > cfindex2ecfm727830792.runPage(D:wwwroot_CFMX10120appointmentm8.comwwwrootindex.cfm:24) > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) > at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) > at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) > at > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) > at > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) > at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) > at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) > at > coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) > at > > coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.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.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) > at coldfusion.CfmServlet.service(CfmServlet.java:107) > at > coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) > at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) > at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown > Source) > at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown > Source) > at > com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown > Source) > 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:541) > at > > jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) > at > > jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) > > > Links: > ------ > [1] http://www.appointmentm8.com/samplescripts/test/storedProc.cfm > [2] http://www.appointmentm8.com/ecc > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com <http://www.gradwell.com/> -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
