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
co
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
> 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
AFIK, if you mean lock it while you are processing a page, you can use the
cftransaction tag:
Until the action="commit" part, the records selected will be locked...
However, if you are looking to lock a record while a use makes changes,
remember, the web is stateless... Getting a record
4 matches
Mail list logo