>- 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 [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,
[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
[2]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home,
_______________________________________________
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 -<
