The timeout attribute of cfquery is in seconds, not milliseconds. CFMX or the JSBC driver may be ignoring it becuase it's so high. Trom something more reasonable like 20 or 30 seconds.
-Cameron On Thu, 13 Jan 2005 23:31:36 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation & Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190389 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
