>- see footer for list info -<
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }
I have added CFDUMP of CFCATCH scope onto the page.
http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
There cfstoredproc works on thsi page but does not on the main page.
Also, I am able to connect with MS Query Analyser and run both the
Stored Proc manually and submit native SQL select statements
correctly so the DB itself appears to be behaving as expected when
connected to directly.
Regards,
Lee
On Wed 7/07/10 12:28 PM , Michael Traher [email protected]
sent:
Hi Lee, Few further questions:
1. Do any of the 3 query types consistantly work - if so can you
just go with that route for now?
2. Would be useful to dump #cfcatch# in the tag and post that dump
here so we can see what the database is complaining about
On 7 July 2010 11:56, wrote:
>- see footer for list info -<
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Morning all,
Russ has directed me to this group to see if you can be of any
help.
I have an ODD set of circumstances that is affecting an application
we
provide.
I have a page which connects to an SQL server which runs 3 queries
which are effectively the same. The address of this page is
http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm [2]
[1]
The split of this page is as follows
1. The first query is a native SQL Select statement using CFquery.
2. The second query is a native SQL EXEC statement which exectutes
a
Stored Procedure using CFquery.
3. The third query is a cfstoredproc command running the same query
as in number 2 above.
These are wrapped in CFTRY and CFCatch tags accordingly. After each
query I am CFDumping the query as a whole (which would only export 1
result typically), and then checking the value of the RecordCount to
ensure the value is 1
At the moment, number 1 fails and 2 and 3 suceed. yesterday all 3
were working up until 23:46.
NOW, on the following page
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[3],
[2] the system also makes a call to this same stored procedure as in
no. 3 using the same code but the request for the recordcount fails.
I have FusionDebug on the system but I am not that up to speed with
using it to be able to track any issues a down.
This has been happening on and off for the last 10 days and appears
to heal itself randomly which makes it very difficult to find the
error as I cannot reproduce the problem except when it actually is
happening. Unfortunately this means my clients cannot get access to
their service which is causing me a major issue.
I am therefore at your mercy, please help!
Links:
------
[1] http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
[4]
[2]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[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 -<
--
Regards Mike
Links:
------
[2] http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
[3]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[4] http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
[5]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[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 -<
