> A long time ago, I made a really stupid mistake that results in deletion >of all data from a table...
A tip I picked up from somewhere - it might even have been this list - is to not ever actually delete records using code. Instead, I have a dtDeleted field, which is set to the current date when I want to delete the record. When doing selects, I add "WHERE dtDeleted IS NULL" to get only non-deleted records. I had an admin section which was secured using session variables. Records kept being deleted in big batches. It took a long time to track down, but it turned out the client was using the Alexa toolbar in his browser - the program managed to capture his username and password as well as urls he visited, and use that to spider the site for the internet wayback machine. In that case all took to stop it was a robots.txt file. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
