>>Where'd you use row level locking? A real life example? This example has already been described in this thread:
« 1. Bob opens a web page and goes to an edit tool and selects "jenny" to edit. 2. Sally opens a web page and goet to an edit tool and also selects "jenny" to edit. 3. Bob updates "jenny" with new information... 4. A minute later Sally updates "jenny" with new information 5. Sally's update has overwritten Bobs - but sally never saw bob's information ..... She only saw the original information » This situation may happen every day in any application in which many users have access to editing facilities. Of course, if only one user can edit, you have no problem. (unless this one user horses around with two browsers in the same time ;-) What one should do normally is to lock the row for Jenny when selcting Jenny for editing, and unlock it either after a time limit, or after updating the record. This way, Sally would get a massage like "Sorry, but Jenny is already being edited by anothe user"... -- _______________________________________ 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:252539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
