Locking a record in database!!

2002-06-12 Thread Chakka, Sudheer
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.

RE: Locking a record in database!!

2002-06-12 Thread Costas Piliotis
PROTECTED]] Sent: Wednesday, June 12, 2002 2: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 particul

RE: Locking a record in database!!

2002-06-12 Thread Dave Watts
> 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. The short answ

RE: Locking a record in database!!

2002-06-12 Thread Bryan Love
ot;...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:37 PM To: CF-Talk Subject: RE: Locking a record

RE: Locking a record in database!!

2002-06-12 Thread Mark A. Kruger - CFG
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 i