@Claude: I know I'm a little late to help but just thought I'd mention experiences. Once I found the the CFQUERY timeout error was mis- leading. I had a web-service call prior to a CFQUERY and for some reason CF was blaming the query. I proved this by pulling the query out and putting some other action in and it blamed that. All I'm saying is, look at the code before the query such as you Excel/XML read. Looks like Steve's extended timeout sort you out anyway.
Cheers Matthew On Jun 9, 10:43 pm, <[email protected]> wrote: > 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: <mailto:[email protected]> [email protected] > Website: <http://www.TrackingCentral.com.au>www.SAMARIS.net > 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]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
