The stats are not that critical but I guess I could dump the code as is and redo it to do a select first. The other thing that I was considering was keeping accumulators in application vars and updating the database hourly but I was concerned that we'd lose some data if cf were restarted.
Thanks for all the suggestions. Regards, Howie --- On Wednesday, February 02, 2005 5:01 PM, Ian Skinner scribed: --- > > What happens if the error that causes the first failure is something > else BESIDES an attempted insertion of a duplicate record? Assuming > ANY all errors will be this one type sounds like an awfully big > assumption. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:192829 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