Standard database procedures in all cases unless you are 100% certain that the record cannot exists is to read before write..check the database to see if the record exists before inserting it. If it does, and you're on a page that only does inserts, you can throw away the second instance or update the existing record.
At 07:56 PM 1/8/02, Dave wrote: >Is Their a Standard Way of Preventing Users from Entering Double Records >by Refreshing Browser? ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
