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]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
