Re: delete after x

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19602
interpreted = N
texte = Assuming that you have a field in the database for the date the record was entered, just put something like the following on your home page (or another frequently hit page):[Delete db=mydatabase.db&leDateEntereddatarq=[math date][date]-30[/math]&DateEnteredtype=date]-Dave At 11:25 AM 8/26/98, shane@ims1.com wrote: >does anyone know of a way to delete a record(s) after a certain amount of >time? A client would like to make sure that records only last 1 month. Is >there any kind of difference tag i.e. the difference between [day of year >entered] and [day of year today] > 30. > >Any ideas? > >---------------------------------------- >Shane P. McNelly mailto:shane@ims1.com >internet Marketspace http://www.ims1.com >http://www.columbusrealestate.com >http://www.interactiveink.com o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Associated Messages, from the most recent to the oldest:

    
  1. Re: delete after x (bob 1998)
  2. delete after x (shane@ims1.com 1998)
  3. Re: delete after x (Dave MacLeay 1998)
Assuming that you have a field in the database for the date the record was entered, just put something like the following on your home page (or another frequently hit page):[Delete db=mydatabase.db&leDateEntereddatarq=[math date][date]-30[/math]&DateEnteredtype=date]-Dave At 11:25 AM 8/26/98, shane@ims1.com wrote: >does anyone know of a way to delete a record(s) after a certain amount of >time? A client would like to make sure that records only last 1 month. Is >there any kind of difference tag i.e. the difference between [day of year >entered] and [day of year today] > 30. > >Any ideas? > >---------------------------------------- >Shane P. McNelly mailto:shane@ims1.com >internet Marketspace http://www.ims1.com >http://www.columbusrealestate.com >http://www.interactiveink.com o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

WebCatalog can't find database (1997) Need help with form (1998) Is this possible in simple search? question? (1998) autocommit problem (1998) unusual search problem (1998) One per customer (2000) The force has left me. (2002) Forms Search Questions (1997) PCS Frames-Default page is solution! (1997) Configuring E-mail (1997) A little syntax help (1997) Secure Server (1997) WebCat: Paying affiliates commissions?? (2000) Showif, Hideif reverse logic ? (1997) RE: Problems with dbcatalog.exe (1997) WebCatalog 4 Install Problems (2000) Online reference (1997) # of real domains on 1 web server (1997) Kaaaaahhhhhhhnnnnnnn! (1997) [WriteFile] problems (1997)