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] <mailto:[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] <mailto:[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] <mailto: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] <mailto: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. -- 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. -- 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.
