database delete help (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database



Message

webgyrl -> database delete help (5/27/2009 20:22:40)

is there a way one can set up a database to automatically delete a record on a certain date. For example delete postings after 30 days?



Spooky -> RE: database delete help (5/27/2009 23:55:38)

Not as such - you can script a page to check the data and run a delete query every time the page is viewed.

The other way to look at it is to keep all records, however only show those records that are newer than 30 days old.



webgyrl -> RE: database delete help (6/3/2009 16:20:20)

how would i write it to select those records younger than thirty days?



TexasWebDevelopers -> RE: database delete help (6/4/2009 10:42:43)

You can easily modify this
http://www.texaswebdevelopers.com/examples/expirydate.asp



webgyrl -> RE: database delete help (6/4/2009 14:30:34)

thanks!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875