>- see footer for list info -< 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 <cfcatch> tag and post that dump here so we can see what the database is complaining about
On 7 July 2010 11:56, <[email protected]> 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 [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 -< > -- Regards Mike _______________________________________________ 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 -<
