Updating a database once per day - An example

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17963
interpreted = N
texte = Here's an example of how I implemented a solution for making sure that Webcatalog is using the most recent copy of mydatabase.db:Rather than issuing an Applescript to tell Webcatalog to close databases at a certain time each day, I generated some WEBDNA that will close a specific database the first time it is needed after 3:10am.Here's the code: [SHOWIF [LOOKUP DB=flush.db&value=[url][date][/url]&lookinfield=DATE1&returnfield=TIME1¬found =NOT_FOUND]=NOT_FOUND][SHOWIF [time %H]>2] [SHOWIF [time %M]>9] [CLOSEDATABASE ../mydatabase.db] [CLOSEDATABASE FLUSH.DB] [APPEND flush.db]DATE1=[URL][date][/URL]&TIME1=[URL][TIME][/URL][/APPEND] [/SHOWIF][/SHOWIF][/SHOWIF]--------------------- flush.db:DATE1 TIME1 05/28/1998 14:48:50 05/29/1998 07:18:43---------------------- I welcome all questions and suggestions.-Steve----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487 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)
Here's an example of how I implemented a solution for making sure that Webcatalog is using the most recent copy of mydatabase.db:Rather than issuing an Applescript to tell Webcatalog to close databases at a certain time each day, I generated some WEBDNA that will close a specific database the first time it is needed after 3:10am.Here's the code: [SHOWIF [LOOKUP DB=flush.db&value=[url][date][/url]&lookinfield=DATE1&returnfield=TIME1¬found =NOT_FOUND]=NOT_FOUND][SHOWIF [time %H]>2] [SHOWIF [time %M]>9] [CLOSEDATABASE ../mydatabase.db] [CLOSEDATABASE FLUSH.DB] [APPEND flush.db]DATE1=[url][date][/URL]&TIME1=[url][time][/URL][/APPEND] [/SHOWIF][/SHOWIF][/SHOWIF]--------------------- flush.db:DATE1 TIME1 05/28/1998 14:48:50 05/29/1998 07:18:43---------------------- I welcome all questions and suggestions.-Steve----------------------------------------------------------------------- Steve Rosenbaum Pop Art L.L.C. http://pop-art.com steve@pop-art.com Networks / Databases / Multimedia7000 SW Hampton St., Suite 124, tel: (503) 968.5957 Tigard, OR 97223-8361 fax: (503) 620.8487 Steve Rosenbaum

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:

READFILE command? (1998) Signal Raised (1997) [WebDNA] [middle] (2015) PayPal WebMerchant Templates (2006) Reversed words (1997) CC verification (2001) unable to launch acgi in WebCat (1997) Loss in form (1998) help with autenticate (1998) Document Contains No Data! (1997) Server crash (1997) [WebDNA] Webserver does not respond occasionally (2018) WebCat2b13MacPlugin - nested [xxx] contexts (1997) WC3 and SSL on NT (1998) A quickie question (1997) Listserver problem (1997) WebCat2 - many [carts] on one template page? (1997) Emailer file formats (1998) Encrypting WebDNA Templates (1999) Shopping cart not being assigned (1999)