Re: Date stamp and purging
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17788
interpreted = N
texte = When the ad is placed, encode today's date + 90 days in a field and call it[expiredate]. Then just set up a template that deletes any of those recordsthat have an [expiredate] field that is older than today's date, and hit thetemplate every few days. Around the end of August, the oldest records willbegin to be deleted. Ken Grome posted some real useful date formattingguidelines a few days ago; you might weant to search the archives for that. Allan Morrison wrote:> > I'm setting up a classified ad site, and I'd like to have ads older than> 90 days purged automatically. How would I go about setting up something> like this.> > Allan Morrison> WebMaster> www.majestictech.com-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (732) 469-2567 ** 429 St. Giles Court * FAX: (732) 469-5823 ** Somerset, NJ * e-mail: help@altimac.com ** 08873 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
When the ad is placed, encode today's date + 90 days in a field and call it[expiredate]. Then just set up a template that deletes any of those recordsthat have an [expiredate] field that is older than today's date, and hit thetemplate every few days. Around the end of August, the oldest records willbegin to be deleted. Ken Grome posted some real useful date formattingguidelines a few days ago; you might weant to search the archives for that. Allan Morrison wrote:> > I'm setting up a classified ad site, and I'd like to have ads older than> 90 days purged automatically. How would I go about setting up something> like this.> > Allan Morrison> WebMaster> www.majestictech.com-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (732) 469-2567 ** 429 St. Giles Court * FAX: (732) 469-5823 ** Somerset, NJ * e-mail: help@altimac.com ** 08873 * WWW: http://www.altimac.com ***************************************************************
Gil Poulsen
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:
Robert Minor duplicate mail (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
[WebDNA] error on mirror site (2015)
Online reference (1997)
Webdna Email and Plesk Control Panel (2005)
2nd WebCatalog2 Feature Request (1996)
[shownext] not displaying anything but first indices found (2000)
Buying sans cart (1997)
We have Proof (1997)
Help name our technology! (1997)
HomePage Caution (1997)
too many nested [xxx] (1997)
ShowNext - This is Killing me! (1998)
Price problem (1997)
PayFlow Pro (2003)
PIXO support (1997)
Great product and great job ! (1997)
Not really WebCat (1997)
Sorting (2000)
I guess I have a problem with commitment (2003)