Requesttimeout was depreciated in CFMX and will not work at all. Using the
<cfsetting requesttimeout="60">
will work. Using this is even better:
<CFPARAM name="requesttimeout" default="60">
<cfsetting requesttimeout="#requesttimeout#">

This will either use the default 60 seconds in the CFPARAM OR use the
requesttimeout set on the URL.

As for createtimespan(), all it does is return a number that represents the
fraction of a day. There's an article on the front of HoF about insane
optimization with this and how the function is never really needed.

> Aha !
>
> I've added this as you suggested.
>
> Doesn't seem to make any difference,  I still get a "The request has
> exceeded the allowable timelimit tag: cfquery" message.
>
> If I set this up in the calling page,  do I still need the timeout attribute
> in the queries ?
>
>
> -----Original Message-----
> From: John Beynon [mailto:[EMAIL PROTECTED]
> Sent: 04 December 2003 10:36
> To: CF-Talk
> Subject: RE: Programatically setting the timeout limit.
>
>
> You can use requestimeout= in the URL from the calling page
>
> Jb.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 04 December 2003 10:36
> To: CF-Talk
> Subject: Programatically setting the timeout limit.
>
> Hello all,
>
> I have a sequence of queries running, each of these are quite large but, at
> preset do not time out.
> However,  when I loop over the first query, then run the second and loop
> over that for the third  I get one of two error messages:
> either a "The request has exceeded the allowable timelimit tag: cfquery"  or
> The request has exceeded the allowable timelimit tag: cfloop".
>
> I've tried adding :timeout="#CreateTimeSpan(0,0,10,0)#"  to the queries
> concerned but to no avail.
> How do I either programatically alter the administrator settings or even
> better set the time out for a cfloop ?
> Does anyone have any ideas?
> Usually I wouldn't be happy using such large queries but this is for an
> internal app that can be run in the background.  So timescale is not an
> issue.
> Cheers,
>
> Darren
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to