I am experiencing the most bizarre problems with my CFMX7.01 installation today. Specifically, CF has decided it only occasionally wants to run my stored procedures on SQL Server 2000. Here is what is happening:
I run a page which uses <cfstoredproc> to call my sp. It executes perfectly. A little while later it barfs when I reload the page running the exact same piece of code it successfully processed earlier. While this is happening I then used a regular <cfquery> tag and executed the sp using EXEC in my T-SQL code. Guess what ... worked like a champ. Comment the <cfquery> tag out and re-run the <cfstoredproc> and it barfs again. Very strange. To troubleshoot properly I decided to restart the CF service and run the code again. Magically the <cfstoredproc> tag runs perfectly. All is well, right? Nope, a few moments later while running the same page again the sp call barfs once again. Change my code and go back to <cfquery> combined with T-SQL code to execute the sp and all is well. Restart the CF service and then the <cfstoredproc> tag runs perfectly again. Has anyone ever seen anything like this before? Any suggestions. Thanks in advance for any help/replies of encouragement. -Jeff Lucido ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
