Using a MX and MySQL on a shared server. I am running some updates in a scheduled event, i.e., no user there to reload the page.
I have an UPDATE CFQUERY in a loop, where it loops a variable number of times, up to about 75. The query times out somewhere in the 10 to 30th loop Query "timeout" is set to 15000 milliseconds, but it always times out in the 5 second range. I am using a CFTRY and CFCATCH which catches problems I can induce, e.g., misspelled variable or DNS, but it doesn't catch the timeout? Question 1. Any ideas on how to beat the time out? Question 2. Even if I can beat the timeout, I would like to trap all errors and log in an error log, and continue on completing the process. But, the durn thing is aborting with the timeout errors. Any ideas, suggestions, etc? Thanks, Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Now there’s a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free. http://www.houseoffusion.com/banners/view.cfm?bannerid=63 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190388 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
