I have an application where one set of people can enter some details about a set of jobs, and another set can review these and approve or reject them, which feeds back to the first set. My problem is how to lock the records in the Oracle database while the 2nd set is reviewing them, so the 1st set can't edit them, and the 2nd set then approve something with different details to what they saw. I've tried using 'select ... for update' to lock the records, and then 'select ... for update nowait' to check for a lock, but ColdFusion is issuing an implict 'commit' when the page is sent to the browser (I think), so this never works (the no wait always succceds). I'm sure some of you must have come across a need to solve this sort of problem - how did you do it ? I'm trying to avoid kludgy things like keeping a list if primnary keys in application.theseAreLocked, and checking that, as the list may become very large. Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
