oh yeah - I was thinking of sessionTimeout and applicationTimeout On 9 June 2010 21:18, Steve Onnis <[email protected]> wrote:
> yes you can. i do it all the time for long request pages. requesttimeout > supersedes the cfadmin values > > as per the cfdocs for the description of requesttimeout > > integer; number of seconds. Time limit, after which ColdFusion processes > the page as an unresponsive thread. Overrides the time-out set in the > ColdFusion Administrator. > > ------------------------------ > *From:* AJ Mercer [mailto:[email protected]] > *Sent:* Wednesday, 9 June 2010 11:07 PM > *To:* [email protected] > *Subject:* Re: [cfaussie] CF Query Timeout > > you can put a big number in for requesttimeout, > but you will not be able to exceed the limit set in the CF administrator > > you may want to check with them to see what it is set at > > On 9 June 2010 21:00, Steve Onnis <[email protected]> wrote: > >> try putting a cfsetting at the top of the page >> >> <cfsetting requesttimeout="9999999" /> >> >> ------------------------------ >> *From:* [email protected] [mailto:[email protected]] >> *Sent:* Wednesday, 9 June 2010 10:44 PM >> *To:* [email protected]; [email protected] >> *Subject:* [cfaussie] CF Query Timeout >> >> Hi >> >> >> >> Is there a way that I have prevent the cfquery from timing out >> >> >> >> The sit is running on cf8 server in a shared hosting environment >> >> >> >> I am creating a complex excel spreadsheet using <cfxml variable="varname”> >> that holds the xml for up to 20 different worksheets created on the fly. >> >> >> >> Given the volume of records in each worksheet often I generate the error >> >> >> >> Error Occurred While Processing Request >> >> *The request has exceeded the allowable time limit Tag: CFQUERY * >> >> >> >> >> >> I have tried to specify the timeout value in each query to a large amount >> of time however the timeout error still generates within 1 minute of the >> page starting to process the data. >> >> >> >> I have ensured that I am running queries of queries where possible to >> prevent unnecessary queries to the sql database however this seems not to >> have had any effect. >> >> >> >> If anyone has some suggestion I would be grateful. >> >> >> >> >> >> >> >> Regards >> >> Claude Raiola (B.Econ Acc; B.Hot. Mngt) >> Samaris Software >> Email: [email protected] <[email protected]> >> Website: www.SAMARIS.net <http://www.TrackingCentral.com.au> >> Mobile: 0414 228 948 >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "cfaussie" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<cfaussie%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/cfaussie?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "cfaussie" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<cfaussie%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/cfaussie?hl=en. >> > > > > -- > > AJ Mercer > http://webonix.net > http://twitter.com/webonix > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<cfaussie%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<cfaussie%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- AJ Mercer http://webonix.net http://twitter.com/webonix -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
