Re: Date stamp and purging
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17804
interpreted = N
texte = >Why bother with all the extra database fields? Just put something like the>following into a page somewhere in the site (assuming you already have a>field for the date the ad was posted):>>[Delete db=yourdatabase.db&leDatePosteddatarq=[math>date]{[Date]}-90[/math]&DatePostedtype=date_mdy]>>Or, if you're worried about the performance hit this may cause, put it on>its own page somewhere and use PageSentry to hit that page once a day...You certainly don't need to rely on PageSentry to do this for you, it's very easy to configure entirely within WebCatalog or Typhoon. In fact, I think I wrote some drop-in code for WebCatalog/Typhoon -- maybe 6 months or a year ago -- that performs any task you define just once a day. Isn't that code still on the PCS web site somewhere? I think it was in a downloadable stuffit archive called DailyTasks ...Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>Why bother with all the extra database fields? Just put something like the>following into a page somewhere in the site (assuming you already have a>field for the date the ad was posted):>>[Delete db=yourdatabase.db&leDatePosteddatarq=[math>date]{
[date]}-90[/math]&DatePostedtype=date_mdy]>>Or, if you're worried about the performance hit this may cause, put it on>its own page somewhere and use PageSentry to hit that page once a day...You certainly don't need to rely on PageSentry to do this for you, it's very easy to configure entirely within WebCatalog or Typhoon. In fact, I think I wrote some drop-in code for WebCatalog/Typhoon -- maybe 6 months or a year ago -- that performs any task you define just once a day. Isn't that code still on the PCS web site somewhere? I think it was in a downloadable stuffit archive called DailyTasks ...Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
emailer (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
showif and cart (1998)
URGENT - CPU usage OSXS (2001)
FM PRO Compatibility Issue - Single Database w/o Conversions (1997)
Problems with date math (1997)
Comments in db? (1997)
Special characters & [sendmail] (1998)
Separate SSL Server (1997)
Banner DNA (1997)
Test ... (2003)
two unique banners on one page (1997)
Server IP Address (2003)
[WebDNA] [announce] WebDNA Site and Store (2008)
HELP WITH DATES (1997)
Further tests with the infamous shipCost (1997)
Fwd: FW: Purchase Command error (1997)
Help!!!! Purchases not going through! FIXED! (1997)
Looping control (1997)