>How about using http://tmda.net/config-vars.html#DB_BARE_APPEND in
>conjunction with a matching 'from-sql' rule in your incoming filter
>file? Then perhaps you could periodically purge entries from the
>database that exceed your desired expiration period?
To really make this work with little manual intervention, you will want to
add an expiration_date column to the table that you are DB_BARE_APPENDing to
and only select rows from that table with a from-sql rule where the record
has not yet expired.
Just out of curiosity, can the DB_BARE_APPEND rule have more than one sql
statement in it such that the above scenario could use an insert and then an
update statement so that future correspondences to an individual extend the
expiration date?
BEGIN:VCARD
VERSION:2.1
N:Grimberg;David;J;Mr.
FN:David J Grimberg
ORG:Pacific Lutheran University;Computing & Telecommunications
TITLE:Systems Analyst
ROLE:Systems Analyst
TEL;WORK;VOICE:(253) 535-7546
TEL;WORK;FAX:(253) 536-5099
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;Computer Center;Pacific Lutheran University=0D=0AComputing & Telecommunicat=
ions;Tacoma;WA;98447;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Computer Center=0D=0APacific Lutheran University=0D=0AComputing & Telecommun=
ications=0D=0ATacoma, WA 98447=0D=0AUnited States of America
X-WAB-GENDER:2
KEY;X509;ENCODING=BASE64:
MIICSTCCAbKgAwIBAgIDCwdFMA0GCSqGSIb3DQEBBAUAMGIxCzAJBgNVBAYTAlpB
MSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD
EyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTAeFw0wMzEwMjkx
NzUxMjZaFw0wNDEwMjgxNzUxMjZaMEIxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFp
bCBNZW1iZXIxHzAdBgkqhkiG9w0BCQEWEGdyaW1iZWRqQHBsdS5lZHUwgZ8wDQYJ
KoZIhvcNAQEBBQADgY0AMIGJAoGBAOniwGPQGo8zKXca1PRimErYv453nLCgpHtr
9EUU1nOt2J3M/pj5Pak2hB6urDR0H9YCf8b0scBnRh1sqa0qn8b9a3caiiTUhzAO
lD7iOzy6D5r1kZmJganwsKIooEPuzF1PCcIqyu3K8xnXxONy1Ts8mKe34/CROYJr
oGVwlzzrAgMBAAGjLTArMBsGA1UdEQQUMBKBEGdyaW1iZWRqQHBsdS5lZHUwDAYD
VR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQB1GRxX8Ng2dJmH5RVBgqxFJH5U
eAM8/ZlXtR7PCfB1UobFB8HggiQtNWh/Ni6te/soOkKAGLeNHcv7Q63WyS2CLOuc
4rAVI3GMjAqcx2+pxwPpFc1hkCaGKfgvQiuRjKUIISZ1j4vx6gHxDhNNpVb2+5CL
6DBkiZabGC9LQuEALw==
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
URL;WORK:http://www.plu.edu/~grimbedj/
FBURL:http://plu.edu/~grimbedj/grimbedj.vfb
REV:20010405T212229Z
END:VCARD
_____________________________________________
tmda-users mailing list ([EMAIL PROTECTED])
http://tmda.net/lists/listinfo/tmda-users
