Erm...I dont think so, well not for Access anyway as I (though I cant be sure, as I havent used Access for donkey's) am not sure what level of isolation it supports.
It could do,as the Database engine itself should handle locking. If you want to be safe, I would say bung it in a cflock and be done with it. -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 14:41 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL INSERT INTO > all cftransaction will allow > you to do is rollback any changes should you pass in crappy code for the > insert I thought, in this instance, where the possibility exists that another user cause a simultaneous insert to occur, the cftransaction ensured that the MaxID value returned by the select was the value previously inserted in the preceding lines of code. Not so? -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
