>- see footer for list info -<
Thanks Charlie, 

Will give it a shot.

Lee Fortnam

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart
Sent: 30 November 2006 04:53
To: 'Coldfusion Development'
Subject: RE: [CF-Dev] Stored Proc Timing out????

>- 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 
>-<

_______________________________________________

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 -<

Reply via email to