>- 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 -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
