Just remember that CF only *suggests* isolation levels and the DB actually does the isolation. There are four isolation levels, with most DB using read committed as the default level.
TK ----- Original Message ----- From: "Doug Bezona" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, September 07, 2006 10:23 AM Subject: RE: Locking Theory > Cftransaction with the isolation attribute. Check the docs for the > various options. > >> -----Original Message----- >> From: Claude Schneegans [mailto:[EMAIL PROTECTED] >> Sent: Thursday, September 07, 2006 10:19 AM >> To: CF-Talk >> Subject: Re: Locking Theory >> >> Ok, the definitions says : >> "A race condition occurs when multiple processes access and manipulate >> the same data concurrently" >> >> I remember, when I was working on applications in Clipper ages ago, we >> had to lock records or files >> in the database, and those locks were managed by DOS, not by the >> application. >> >> In CF locks appear to be purely software locks, I mean only parts of > the >> program are locked, >> not records nor tables in the database. >> For my applications, I have no problem presently as few people are >> working in the same time, >> but in general, how would you lock a certain record in a table while >> some one is >> working on it ? >> >> -- >> _______________________________________ >> REUSE CODE! Use custom tags; >> See http://www.contentbox.com/claude/customtags/tagstore.cfm >> (Please send any spam to this address: [EMAIL PROTECTED]) >> Thanks. >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
