Thanks for clarifying. So by "recoverable," do you mean a problem where the server is temporarily unavailable? If that's the case, eeek. That's a bad situation to be in. Generally, it just doesn't happen, so this isn't a problem you typically have to solve.
What you may want to consider in this case is some basic error catching and some kind of framework to handle failed queries in a predictable, user-friendly manner, like a nice error page, maybe a way to let the user retry the exact request. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] On Fri, Apr 3, 2009 at 4:50 AM, Byte Me <[email protected]> wrote: > > > Is there a rule of thumb on how many times a query should be retried? > > Thank you for the info everyone. I'm using Mysql and I'm not getting any > errors, I'm just trying to use good programming practices so the end user > will not see any error messages, in the event that a recoverable error is > generated by the database. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
