Re: seeking mailing list from SQL
On Thu, Oct 02, 2003 at 10:11:15PM +0200, martin f krafft wrote:
> also sprach Mark Ferlatte <firstname.lastname@example.org> [2003.10.02.2156 +0200]:
> > remove_members --all mylist
> > mysql -h localhost -e "SELECT email from people" mydb | \
> > add_members -n - -c n -w n mylist
> I know about the script possibility, but what then if someone
> unsubscribes from the mailinglist a minute before a new mail is
> sent. People get annoyed about these things, trust me. And I can't
> run a cron script every minute. I'd much rather have the mailing
> list manager contact the database when it's needed.
How about a trigger in the database that runs the script ? I never tried
it, but it should work
> Please do not CC me when replying to lists; I read them!
> .''`. martin f. krafft <email@example.com>
> : :' : proud Debian developer, admin, and user
> `. `'`
> `- Debian - when you have better things to do than fixing a system
> Invalid/expired PGP subkeys? Use subkeys.pgp.net as keyserver!