I have a template timeout set in the administrator that works. but upon researching the issue I discovered that the template timeout does not apply to queries, that coldfusion basically hands the template off to the database and waits for it to come back. if the database takes longer than the time limit to return the results,the page will be timed out upon its return and not untill then. Therefore my understanding is if a query is taking a long time for whatever reason you need to use the timeout attribute of the query tag if you want to stop it, and in testing this worked but now it appears to not be working hence the 60 second timeout warning in the log files which is the default time limit of the datasource.
On Mon, 27 Dec 2004 14:20:09 -0500, Tangorre, Michael <[EMAIL PROTECTED]> wrote: > > From: Ron G [mailto:[EMAIL PROTECTED] > > Why would the timeout value of the cfquery tag be ingnored? > > Ron, > > The query timeout is for that query not the template as a whole. Use > cfsetting to override the administrator setting if you need to timeout a > template with different settings than that which is in the cf admin. > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pc6.htm#wp11 > 03514 > > HTH, > > Mike > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
