> Consider the scenario of another application accessing the same database. > An application scoped lock won't be honoured by a foreign application. The > ONLY sure fire way to ensure atomic transactions is to have the db engine > take care of it. CFLOCK & CFTRANSACTION = apples & oranges, chalk & > cheese, etc.
Ahh, of course -- I hadn't considered the situation where another application could read / write to the db. -- 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]
