>- see footer for list info -<
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }The
actual DB does not seem to be failing with any connection attempt.
Using the DEBUG option if CFADMIN shows this info back from the
queries.
D:wwwroot_CFMX10120appointmentm8.comwwwrootSampleScriptsteststoredProc.cfm
@ 12:42:07.765
name
res_APPM8_GET_CLIENT_DETAILS_query
statement
SELECT
APPM8_WLC.*, APPM8_ClientTypes.ClientType,
APPM8_ClientTypes.ClientTypeID
FROM
APPM8_WLC INNER JOIN APPM8_WLCDomains ON APPM8_WLC.ClientID =
APPM8_WLCDomains.ClientID INNER JOIN APPM8_ClientTypes ON
APPM8_WLC.ClientTypeID = APPM8_ClientTypes.ClientTypeID
WHERE
APPM8_WLCDomains.URL = 'www.appointmentm8.com/solihullcaretrust'
datasource
d8m8
record count
-1
execution time
0ms
D:wwwroot_CFMX10120appointmentm8.comwwwrootSampleScriptsteststoredProc.cfm
@ 12:42:07.921
name
res_APPM8_GET_CLIENT_DETAILS_query
statement
EXEC d8m8_communicationm8.spr_APPM8_GET_CLIENT_DETAILS
@URL="www.appointmentm8.com/solihullcaretrust"
datasource
d8m8
record count
1
execution time
0ms
D:wwwroot_CFMX10120appointmentm8.comwwwrootSampleScriptsteststoredProc.cfm
@ 12:42:07.937
procedure
spr_APPM8_GET_CLIENT_DETAILS
datasource
d8m8
execution time
0ms
type
CFSQLType
value
variable
dbVarName
IN
CF_SQL_VARCHAR
www.appointmentm8.com/solihullcaretrust
name
resultset
res_APPM8_GET_CLIENT_DETAILS
1
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 [6]
[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
[7],
[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
[8]
[2]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[9],
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists,
go to http://list.cfdeveloper.co.uk/mailman/listinfo [10]
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk [11] -<
>- Lists hosted by www.Gradwell.com [12] -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
--
Regards Mike
Links:
------
[6] http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
[7]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[8] http://www.appointmentm8.com/SampleScripts/test/storedProc.cfm
[9]
http://www.appointmentm8.com/solihullcaretrust/index.cfm?fuseaction=c_general.home
[10] http://list.cfdeveloper.co.uk/mailman/listinfo
[11] http://www.cfmxhosting.co.uk
[12] 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 -<
