>- see footer for list info -< Are you using CFSTOREDPROC to call it? It doesn't appear that that offers a TIMEOUT attribute. But you could use CFQUERY instead, which does offer a TIMEOUT. (Of course, if you already are using CFQUERY, then adding TIMEOUT should sort you.)
If you've not used CFQUERY to call a stored procedure, it's the "old school" way (pre-CF4 when CFSTOREDPROC was added). The proper form to call an SP may depend on the DBMS you're using, but typically it was done with EXEC spname in place of the normal SQL statements within a CFQUERY. Let us know if any of that helps. /Charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam Sent: Wednesday, November 29, 2006 7:49 PM To: 'Coldfusion Development' Subject: [CF-Dev] Stored Proc Timing out???? >- see footer for list info -< Hi All, Started to receive a timeout on a stored proc, is there any time to extend the time permitted for this tag to complete its actions? Lee Fortnam _______________________________________________ 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 -<
