Re: Updating a database once per day - An example

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17973
interpreted = N
texte = On 5/31/1998 11:29 pm, Kenneth Grome so noted...>If you want to make sure this manual updating process works properly >without any problems, other than *possibly* a visitor or two getting an >Error: the database 'test.db' could not be found or opened message >during the process (which should take no more than a second or two at the >most), do this in your update template: > >[DELETEFILE] <--trash the current db file >[CLOSEDATABASE] <--purge the RAM cache >[MOVEFILE] <--move the new db file into place > >This insures that when it's time to move the new db file into position, >the old data is already purged from RAM ... and the old db file could not >be reloaded because it wasn't there to be reloaded -- it was already >deleted from disk.It's my understanding that [closedatabase] writes out any modifications to disk before closing -- will it create a new file if the expected database file is missing? Probably a moot point, since I currently have autocommit turned on, but if I didn't?Getting the database not found error for those few seconds would probably be acceptable (albeit kludgy). Is there way to tell the ErrorMessages.db to point to a custom error page of my own design, or do I need to squeeze one huge, unbroken line of HTML into that db's Message field? And if that's the case, can there be multiple ErrorMessages.db files to handle customization on a site by site basis?I know that this thread comes 'round every couple months or so. It would be good to have some definitive word on the (apparently common) subject from PCS, or some additional tags/tools with WebCatalog to make the process easier.Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Updating a database once per day - An example ( 1998)
  2. Re: Updating a database once per day - An example (bob 1998)
  3. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  4. Re: Updating a database once per day - An example (Steve Rosenbaum 1998)
  5. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  6. Re: Updating a database once per day - An example (Marty Schmid 1998)
  7. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  8. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  9. Re: Updating a database once per day - An example (Gary Richter 1998)
  10. Re: Updating a database once per day - An example (Peter Ostry 1998)
  11. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  12. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  13. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  14. Re: Updating a database once per day - An example (Peter Ostry 1998)
  15. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  16. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  17. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  18. Re: Updating a database once per day - An example (Rob Marquardt 1998)
  19. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  20. Re: Updating a database once per day - An example (Steve Rosenbaum 1998)
  21. Re: Updating a database once per day - An example (Kenneth Grome 1998)
  22. Updating a database once per day - An example (Steve Rosenbaum 1998)
On 5/31/1998 11:29 pm, Kenneth Grome so noted...>If you want to make sure this manual updating process works properly >without any problems, other than *possibly* a visitor or two getting an >Error: the database 'test.db' could not be found or opened message >during the process (which should take no more than a second or two at the >most), do this in your update template: > >[deletefile] <--trash the current db file >[closedatabase] <--purge the RAM cache >[movefile] <--move the new db file into place > >This insures that when it's time to move the new db file into position, >the old data is already purged from RAM ... and the old db file could not >be reloaded because it wasn't there to be reloaded -- it was already >deleted from disk.It's my understanding that [closedatabase] writes out any modifications to disk before closing -- will it create a new file if the expected database file is missing? Probably a moot point, since I currently have autocommit turned on, but if I didn't?Getting the database not found error for those few seconds would probably be acceptable (albeit kludgy). Is there way to tell the ErrorMessages.db to point to a custom error page of my own design, or do I need to squeeze one huge, unbroken line of HTML into that db's Message field? And if that's the case, can there be multiple ErrorMessages.db files to handle customization on a site by site basis?I know that this thread comes 'round every couple months or so. It would be good to have some definitive word on the (apparently common) subject from PCS, or some additional tags/tools with WebCatalog to make the process easier.Rob Marquardt Designer/Resident Wirehead Toast Design300 First Avenue North, Suite 150 Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com Rob Marquardt

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:

Re[2]: Problem with new formvariables (2000) WebCat2b13 Command Reference Doc error (1997) [WebDNA] two ideas for running a cluster of WebDNA servers (2019) Re:Dumb Question about Docs (1997) Storebuilder SOLVED!!!!!!! (2003) protect acting looney?? (2003) Web Browser %Numbers - A must read for web developers (2003) Unknown exception in WebDNA 4.5.0 (2003) [WebDNA] MD5 Hash issue (2009) any idea (2004) Nested tags count question (1997) Expected Behavior? (1999) UPDATE PROBLEM (1997) 2.0 Info (1997) Quitting WebMerchant ? (1997) Bug (feature) in v6 listfiles shows hidden files ... (2004) [if] and [showif] - A solution (2002) old problem (2001) Single Link browsing (1997) Signal Raised Error (1997)