Re: Updating a database once per day - An example

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17967
interpreted = N
texte = >As you point out, this situation would be for after a database file has >been manually changed.In that case, the best method is to perform these tasks -- all in one template:1- Put the new db in a different folder. 2- Close the current db. 3- Trash the current db you just closed. 4- Move the new db to the folder the old one was in before you trashed it. >Now, what I am trying to accomplish, mydatabase.db (which happens to be >copied from the MainFrame to the Web Server at 3:03AM each night with the >name mydatabase.db) will be closed at 3:10am, and then re-openned with >fresh contents the next time it is needed.Okay, so what you must do is put that newly-created db into a *different* folder than the file it's replacing. Then when you write your WebDNA code, you can do all the tasks above, all in a single template. This is very important, because you must make sure that after WebCatalog closes the current db, another request does NOT open it again before WebCat has replaced it.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>As you point out, this situation would be for after a database file has >been manually changed.In that case, the best method is to perform these tasks -- all in one template:1- Put the new db in a different folder. 2- Close the current db. 3- Trash the current db you just closed. 4- Move the new db to the folder the old one was in before you trashed it. >Now, what I am trying to accomplish, mydatabase.db (which happens to be >copied from the MainFrame to the Web Server at 3:03AM each night with the >name mydatabase.db) will be closed at 3:10am, and then re-openned with >fresh contents the next time it is needed.Okay, so what you must do is put that newly-created db into a *different* folder than the file it's replacing. Then when you write your WebDNA code, you can do all the tasks above, all in a single template. This is very important, because you must make sure that after WebCatalog closes the current db, another request does NOT open it again before WebCat has replaced it.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

Req: Array Tags Explained, simple and clear (2004) WebDNA Solutions ... sorry! (1997) Webcat does auto checksum in [setheader]? (1999) getting images' width/height (1998) can WC render sites out? (1997) Ok here is a question? (1997) SSL and WebCatalog (1997) Document Contains No Data! (1997) find with exceptions (1997) Loop code problem (2000) emailer setup (1997) RE: Sum of Quantities (1997) Error Messages Returned to User (1997) Nested tags count question (1997) Form Variables (2000) Date format problems (1997) [showif],[referer],[include] in errormessages.db (2002) Strange intermittent WebDNA problems (2008) Character limit in [Search]? (1998) WebCat2b13 Command Reference Doc error (1997)