You don't want to do this in the DB. DB locking is for tuning performance and concurrency. What you are referring to is more like application logic. I think I would flag the record in the table and check the flag before opening it for editing - then reset the flag when done. However, you must consider how to "expire" the flag somehow. Since you are unable maintain state, you will not really know when the user goes away - so if a user leaves without finishing the edit, you have a "no-edit" flag set on the record that will remain until something happens. For lots of reasons, doing this is a fairly bad idea in a busy environment.
-Mk -----Original Message----- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:03 PM To: CF-Talk Subject: Locking a record in database!! Hi, Can any one tell me how to lock a record in the table for some time. When One record is opened for writing through a form, I don't anyone else to open that particular record. I don't know at which level this should be done either at Database level or in ColdFusion. I have SQL Server and ColdFusion 5.0 Thanks in advance. Sudheer Chakka ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists