Lets say we have a database connection that hangs. This will cause the template running to hang and then time out. Is there a setting in ColdFusion or in CFQuery that will time out a query regardless of the actual query status? i.e. the query starts running. After 1 minute, the query times out and the time out is caught by a try/catch. the 'real' query is still running in the DB but the template has dropped connection to it.
I'm trying with the timeout setting in CFQUERY as well as some other things but I can't seem to get the query to time out. Does anyone know if this is possible? Has anyone run into this? Thanks p.s. I'll post my results if I can get it to work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219038 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
