>- see footer for list info -< And as if by magic it is up and running again with me having done NOTHING!!!!!! Just don't get it! On Wed 7/07/10 12:39 PM , [email protected] sent: 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 -<
