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 records that have an [expiredate] field that is older than today's date, and hit the template every few days. Around the end of August, the oldest records will begin to be deleted. Ken Grome posted some real useful date formatting guidelines 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 records that have an [expiredate] field that is older than today's date, and hit the template every few days. Around the end of August, the oldest records will begin to be deleted. Ken Grome posted some real useful date formatting guidelines 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:
webcat NT with [dos] command (1997)
Big Databases (1997)
Bug in 4.5 - Needs to be fixed ASAP. (2002)
Help name our technology! (1997)
argh must send var to iframe to load webDNA search (2003)
WebCatalog 3.0.4 alias crash bug? (2000)
Migrating From One Server To Another (2003)
[WebDNA] Feature Request (2013)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
eMail volume (2000)
What is WebDNA (1997)
Sami (1998)
Store Builder Question (1999)
[showif]/[hideif] question (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
For those of you not on the WebCatalog Beta... (1997)
4.0 upgrade pricing (2000)
NT b19 sends extra MIME headers (1997)
Mailer (2006)
Email Set-Up? (1997)