Re: several people editing a database.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38915
interpreted = N
texte = Whoever saves last wins.You would need to implement some sort of record locking, e.g. When someoneis in edit mode, update a flag field in the database that does not letanyone else edit it. Kind of like a pre-edit. Then on saving of the field,clear the flag.The only problem is that if someone just views the details without editingit you could leave that flag set. Maybe add a second field with a time/datestamp and have a trigger run say each hour and clear the flag on any fieldmore than xx minutes old.Daleon 9/26/01 4:27 PM, Donovan Brooke at dbrooke@ehg.net wrote:> quick quesiton:> any input as to whether or not letting mutiple people administer some of the> databases is O.K.?> if two people are editing the same record what happens? thx.> > > -- Donovan D. Brooke> Systems Administrator/> Assc. Art Director> Epsen Hillmer Graphics> > > I know I'm making progress when I look at the questions I have> asked in the past and think to myself... how stupid was that-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Whoever saves last wins.You would need to implement some sort of record locking, e.g. When someoneis in edit mode, update a flag field in the database that does not letanyone else edit it. Kind of like a pre-edit. Then on saving of the field,clear the flag.The only problem is that if someone just views the details without editingit you could leave that flag set. Maybe add a second field with a time/datestamp and have a trigger run say each hour and clear the flag on any fieldmore than xx minutes old.Daleon 9/26/01 4:27 PM, Donovan Brooke at dbrooke@ehg.net wrote:> quick quesiton:> any input as to whether or not letting mutiple people administer some of the> databases is O.K.?> if two people are editing the same record what happens? thx.> > > -- Donovan D. Brooke> Systems Administrator/> Assc. Art Director> Epsen Hillmer Graphics> > > I know I'm making progress when I look at the questions I have> asked in the past and think to myself... how stupid was that-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
dale
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Privacy Issue (LEGIT QUESTION) (2003)
Using tags to create a file name (2000)
show all problem (1997)
Pass Thru Page? (1998)
Error Messages Returned to User (1997)
Multi-processor Mac info ... (1997)
all records returned. (1997)
no template caching (1997)
Superfilous Characters (1998)
'does not contain' operator needed ... (1997)
pc (1997)
Hard Questions ? (1997)
using showpage and showcart commands (1996)
search form problem.. (1997)
Request for page test (2003)
Draft Manual, Tutorial, and more (1997)
restarting webcatalog (2002)
Cool XML/XSLT tool .. (2002)
WC Database Format (1997)
upgrading (1997)