MS SQL locking is implemented as set of hints, for example: SELECT au_lname FROM authors WITH (NOLOCK) (dirty read - fast but dirty :)
or for update as in SELECT au_lname FROM authors WITH (UPDLOCK) (data will not change till you do an update yourself) TK ----- Original Message ----- From: "Claude Schneegans" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, September 08, 2006 10:20 AM Subject: Re: Locking Theory > >>Then I have news for you: the feature is implemented in both ODBC and > JDBC and is standard in SQL. > > Ok, so it should be possible to make some CFX or CFC to handle locks. > > >>SELECT * FROM table WHERE id = blah FOR UPDATE > > Ok, but I think this syntax is proper to Oracle. > - I don't see it documented in Access, SQL Server > - In MySql, there is only LOCK TABLES, > > > -- > _______________________________________ > 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:252542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
