Has the expirator mod for Links2.0 been made for Links SQL? or is it compatible? I really need this mod before I can uprade to links SQL.
Apr 17, 2000, 12:27 PM
User (93 posts)
Apr 17, 2000, 12:27 PM
Post #5 of 7
Views: 2022
I have some links that I'd like to expire (like contests, etc.) and other links which I don't want to expire. Would leaving the Exp_Date field blank on the non-expiring links exempt them from deletion when I run the "delete from Links where Exp_Date < '2000-01-18'" command?
Thanks!
Katina
Thanks!
Katina
Apr 17, 2000, 1:03 PM
Veteran / Moderator (6956 posts)
Apr 17, 2000, 1:03 PM
Post #6 of 7
Views: 2021
For safety's sake I would add something like
((Exp_Date < '2000-01-18') and (Exp_Date != '0000-00-00'))
That way empty date fields are exempted from deletion.
You could also make the test
((Exp_Date < '2000-01-18') and (Exp_Date > '1998-01-01'))
That would delete dates only within the past 2 years.
((Exp_Date < '2000-01-18') and (Exp_Date != '0000-00-00'))
That way empty date fields are exempted from deletion.
You could also make the test
((Exp_Date < '2000-01-18') and (Exp_Date > '1998-01-01'))
That would delete dates only within the past 2 years.