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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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 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:
Conditional searching & displaying (1997)
[WebDNA] ImageMagick code (2013)
Modifying order output (1997)
syntax question, not in online refernce (1997)
Orders coming up blank (2004)
Using WC for Bulk Emailings (1997)
searching multiple databases in single search (1997)
Layers,Dreamweaver and WebCat Code (2000)
[WebDNA] Web Hosting (2008)
Quickie question on the email templates (1997)
[CART] inside a [LOOP] (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
PCS Emailer's role ? (1997)
updating with ProductEditor (1998)
unable to launch acgi in WebCat (1997)
Converting order file to database (1998)
Date Math (2005)
using showpage and showcart commands (1996)
sort problems....bug or brain fart? (1997)
NT b19 sends extra MIME headers (1997)