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
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