>- see footer for list info -<
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Thanks Adrian.
Did that, result below, this is all wrapped in a cftry and there is
nothing being complained about in terms of DB errors
Code in page
#IsQuery(res_APPM8_GET_CLIENT_DETAILS)#
Result
Variable RES_APPM8_GET_CLIENT_DETAILS is undefined
DEBUG reports
Stored Procedures spr_APPM8_GET_CLIENT_DETAILS (Datasource=d8m8,
Time=0ms) in D:wwwroot_CFMX10120appointmentm8.comwwwrootmyGlobals.cfm
@ 20:32:43.043
parameters
type
CFSQLType
value
variable
dbVarName
IN
CF_SQL_VARCHAR
www.appointmentm8.com/solihullcaretrust
resultsets
name
resultset
res_APPM8_GET_CLIENT_DETAILS
1
Have to say this is proving really frustrating :-(
Lee
On Tue 24/08/10 3:33 PM , Adrian Lynch [email protected]
sent:
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, 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 [2]
[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 [3] [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
[4]
[2] http://www.appointmentm8.com/ecc [5]
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists,
go to http://list.cfdeveloper.co.uk/mailman/listinfo [6]
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk [7] -<
>- Lists hosted by www.Gradwell.com [8] -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
Links:
------
[2] http://www.appointmentm8.com/samplescripts/test/storedProc.cfm
[3] http://www.appointmentm8.com/ecc
[4] http://www.appointmentm8.com/samplescripts/test/storedProc.cfm
[5] http://www.appointmentm8.com/ecc
[6] http://list.cfdeveloper.co.uk/mailman/listinfo
[7] http://www.cfmxhosting.co.uk/
[8] http://www.gradwell.com/
_______________________________________________
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 -<
