Re: 100 + Users updating database

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 45875
interpreted = N
texte = On Monday, December 2, 2002, at 01:03 PM, Jesse Williams-Proudman wrote:> On 12/2/02 9:21 AM, Jeff Logan wrote:>>> Does anyone have recommendations/code for doing a trigger that will>> roll a copy of the database every four hours.>> I do... Though I've put some time into it...ok, I'll bite... how much time does it take to write up a simple script that eithera) copies the database file on the disk to a duplicate fileorb) searches the database and writes out all of the found records (i.e. everything) to a new database file (use the [writefile])after that a little triggeriffic goodness, and you're on your way.a more complicated method:You can be like my bank, when someone wants to change a record, it loads that record on a page. You change and submit, and it saves it as a new record to the database and lets you review your changes before it becomes permanent, at which point it keeps the new record and deletes the previous (and now obsolete) record. Until it's approved via a review the old record stays active, and you could do a sweep every so often to get rid of the unfinished record edits. Brian B. Burton 973-263-3036 973-296-6862 (cell) BOFH - Department of Redundancy Department-------------------------------------------------------------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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

On Monday, December 2, 2002, at 01:03 PM, Jesse Williams-Proudman wrote:> On 12/2/02 9:21 AM, Jeff Logan wrote:>>> Does anyone have recommendations/code for doing a trigger that will>> roll a copy of the database every four hours.>> I do... Though I've put some time into it...ok, I'll bite... how much time does it take to write up a simple script that eithera) copies the database file on the disk to a duplicate fileorb) searches the database and writes out all of the found records (i.e. everything) to a new database file (use the [writefile])after that a little triggeriffic goodness, and you're on your way.a more complicated method:You can be like my bank, when someone wants to change a record, it loads that record on a page. You change and submit, and it saves it as a new record to the database and lets you review your changes before it becomes permanent, at which point it keeps the new record and deletes the previous (and now obsolete) record. Until it's approved via a review the old record stays active, and you could do a sweep every so often to get rid of the unfinished record edits. Brian B. Burton 973-263-3036 973-296-6862 (cell) BOFH - Department of Redundancy Department-------------------------------------------------------------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://webdna.smithmicro.com/ Brian Burton

DOWNLOAD WEBDNA NOW!

Re: 100 + Users updating database

2002

Top Articles:

Related Readings: