Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

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>

Reply to this topic