Forums
This topic is locked
automatic delete records in database
Posted 01 Apr 2005 11:43:24
1
has voted
01 Apr 2005 11:43:24 Luc Teirlinck posted:
Hi, I'am looking for a script that checks a database and delete records after an expired date. If its possible a script that checks my database each day.I'am a newbie in vbscript and asp.
Thx for your help on advance
Replies
Replied 01 Apr 2005 15:09:02
01 Apr 2005 15:09:02 Rene Bandsma replied:
A script has to be processed by the server therefore you cannot 'automate' such processes (for I know). You can work with stored procedures if you use an MS SQL database.
Otherwise the script could be very simple.
DELETE * FROM DATABASE WHERE DATE < EXPIRED DATE
<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>
Otherwise the script could be very simple.
DELETE * FROM DATABASE WHERE DATE < EXPIRED DATE
<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>