Re: several people editing a database.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38923
interpreted = N
texte = What I use is a version control field as part of each record stored in thedatabase. The version control field is a date-time stamp using the mathfunction to convert date and time to numbers.When a user draws the record down to edit ... The version control number istagged with the page. If he updates or change the record ... The attachedversion control number is transmitted with the changes where using showifor if statements in the acknowledgement page .... You can then direct theaction to follow.The first thing upon submitting the change ... The acknowledgement page testto see if the record version control number is the same. If it is ... Thenthe change is effected to the record and a new version control controlnumber appended. If it is not ... You can then inform the user that someoneelse has recently updated the record ... Present him with the extract of theupdated record for editing or follow-up. As you can see, if some other userdraws the record down after the first user ... Makes the change before thefirst user did his ... The version control number will change.Very simple but effective control mechanism. If a record has many fields, wefurther breakdown the edit page to present block entries (i.e. Sectionswhere each section is a form covering a subset the fields for that record tochange). This is better since we are also minimizing the amount of dataexchange between client and server instead of the entire record. Withsections, each can have their own version control number as well which meansthat 2 party updating different sections of the same record will not override one another without prior knowledge.Hope that helps ... TDn===========From: dale
Reply-To: (WebCatalog Talk)Date: Wed, 26 Sep 2001 16:33:11To: (WebCatalog Talk)Subject: Re: several people editing a database.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 thedatabases is O.K.?if two people are editing the same record what happens? thx.-- Donovan D. BrookeSystems Administrator/Assc. Art DirectorEpsen Hillmer Graphics-------------------------------------------------------------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:
What I use is a version control field as part of each record stored in thedatabase. The version control field is a date-time stamp using the mathfunction to convert date and time to numbers.When a user draws the record down to edit ... The version control number istagged with the page. If he updates or change the record ... The attachedversion control number is transmitted with the changes where using showifor if statements in the acknowledgement page .... You can then direct theaction to follow.The first thing upon submitting the change ... The acknowledgement page testto see if the record version control number is the same. If it is ... Thenthe change is effected to the record and a new version control controlnumber appended. If it is not ... You can then inform the user that someoneelse has recently updated the record ... Present him with the extract of theupdated record for editing or follow-up. As you can see, if some other userdraws the record down after the first user ... Makes the change before thefirst user did his ... The version control number will change.Very simple but effective control mechanism. If a record has many fields, wefurther breakdown the edit page to present block entries (i.e. Sectionswhere each section is a form covering a subset the fields for that record tochange). This is better since we are also minimizing the amount of dataexchange between client and server instead of the entire record. Withsections, each can have their own version control number as well which meansthat 2 party updating different sections of the same record will not override one another without prior knowledge.Hope that helps ... TDn===========From: dale Reply-To: (WebCatalog Talk)Date: Wed, 26 Sep 2001 16:33:11To: (WebCatalog Talk)Subject: Re: several people editing a database.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 thedatabases is O.K.?if two people are editing the same record what happens? thx.-- Donovan D. BrookeSystems Administrator/Assc. Art DirectorEpsen Hillmer Graphics-------------------------------------------------------------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/
Terry Nair
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:
[shownext] and sort (1998)
Looking for a Manual (1997)
too many nested ... problem (1997)
MacAutorize and T1 (1998)
Security Levels... Possible? (2000)
I have troubles to send message out (1998)
[WebDNA] Send Mail and Outlook Express (2008)
How to remove comments with grep? (2003)
WebCat2.0 acgi vs plugin (1997)
Sku numbers (1997)
Unknown error: OrderNotCreated (1997)
WCS Newbie question (1997)
addlineitems within formvariable loop (1998)
maximu values for sendmail! (1997)
[WebDNA] interesting bug webdna 6 (2012)
Is [thisurl] http or https? (1998)
Can this be done? (1997)
Search in 2 or more catalogs (1997)
Encryption method used for [encrypt]? (2000)
tax rate off by 1 cent (1997)