[thelist] Setting records to expire after a specific time?

Kevin D. White nonzero at well.com
Wed Feb 27 14:15:01 CST 2002


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Super-easy.  Create a new column in the db with a Date datatype.  Put
the expiration date in that column.  Then mod your queries to check
that column against the current date.  The query should only then
return records that expire after the current date.

Can't really say more without knowing what DB you are using and the
table structure.
- ----- Original Message -----
From: "Faye Tarzwell(FayeC)" <ftarzwell at fayec.com>
> Is there a way to set the records to expire a specific time after
> having been entered in the db?

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPH09eVZZFo27GBIvEQLkGACgnX6jMnuFRzTU7yyQNJccPtk5ptIAniYj
Ld1uhXm21zRY5mHkpGV8hfz5
=fe6L
-----END PGP SIGNATURE-----





More information about the thelist mailing list