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:
Timer Values on [redirect] (1998)
WCS Newbie question (1997)
[WC 2.1.30] Stack overflow. (2000)
Text Area - Line Breaks (1998)
problems with 2 tags (1997)
Running 2 two WebCatalog.acgi's (1996)
WebCat2 as a chat server? (1997)
many-to-one problem (1998)
Re:Running 2 two WebCatalog.acgi's (1996)
Virtual Domains (1998)
Browser Back button (2003)
Lineitems [text*] (2004)
[WebDNA] calling a webDNA tmpl from PHP? (2008)
Running _every_ page through WebCat ? (1997)
How far do [showif]s go? (1997)
OT: Sending email to lots of subscribers (1999)
WebCat b13 CGI -shownext- (1997)
taxRate is fine but taxTotal isn't (1997)
Open source store builder (Merchant Maker?) (2003)
Unix Timestamp using WebDNA [code req] (2003)