Forums

This topic is locked

Two date questions

Posted 06 Oct 2002 00:35:49
1
has voted
06 Oct 2002 00:35:49 Jelle-Jacob de Vries posted:
Is it possible, that:

a database automatic delete's a record after it passed a specific date ??

a record becomes vissible after two months before it's needed ??


Are there some scripts available for this ??

Replies

Replied 08 Oct 2002 17:00:38
08 Oct 2002 17:00:38 Matthijs Horsman replied:
hey JelleJacob,

I think the first one can be done with SQL-SERVER scheduling some job.

in the second case you can get only the records form the database that are before or after a certain date using some SQL

here's some simple sql staments you culd use for that
www.ultimateasp.com/tutorial/sql.asp

Good luck

Matthijs
----------------
DWMX/W-XP-PRO/IIS/ASP-VB
www.chaps.nl

Reply to this topic