Re: Date stamp and purging
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17794
interpreted = N
texte = Dave MacLeay wrote: > > 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...I wasn't thinking extra fields. I was thinking 1 extra record. Probably the first record, of course it would be unexpirable and otherwise unfindable by the classifieds section. So the overhead is minimal, no performance hit and no need to pick up page sentry.
Associated Messages, from the most recent to the oldest:
Dave MacLeay wrote: > > 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...I wasn't thinking extra fields. I was thinking 1 extra record. Probably the first record, of course it would be unexpirable and otherwise unfindable by the classifieds section. So the overhead is minimal, no performance hit and no need to pick up page sentry.
Bob Minor
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:
Wanted: full time WebDNA programmer (2005)
[OT] (waaaay OT) (2004)
Getting Rid of Multiple Returns (2001)
WebCat2: Items xx to xx shown, etc. (1997)
[WebDNA] [OT] the "Work in progress" thread. (2009)
WebDNA on OS X Tiger (2006)
Search group and ww (FYI) (2003)
Running _every_ page through WebCat ? (1997)
WCf2 and nested tags (1997)
Cart Number sequence (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
RE: Last desperate attempt (1998)
Resume Catalog ? (1997)
Problem: 3.0 doesn't update carts (1997)
Up and running ... at last !! (1997)
printing twice? and fix (1997)
two domains and one cart and database (2000)
Upcoming 2.1 Release and PCS Committment (1997)
[OT] Death Clock (2003)
Help! WebCat2 bug (1997)