I think cfquery has a timeout attribute too. I mainly use it to stop queries running to long, but maybe it works the other way too.
On Wed, Jun 9, 2010 at 11:55 PM, <[email protected]> wrote: > Thanks Steve, I tried it and it worked a treat > > > > I pushed search criteria to the max to test it and it took 5 minutes to run > the process with the resulting multi workbook spreadsheet containing several > 100 rows of data per workbook, the excel file size ending up being 7 meg > worked perfectly. > > As always we love your work > > 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 > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Steve Onnis > *Sent:* Wednesday, 9 June 2010 11:18 PM > *To:* [email protected] > *Subject:* RE: [cfaussie] CF Query Timeout > > > > 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. > > -- > 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]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
