Christian,
Are you using MySQL or PostgreSQL? I'm not positive of
MySQL, but with Postgres you could set up a trigger on the
dbmail_messages table to fire on insert. There is an
option to execute an external program in postgres from a
function.
This way you would be guarenteed that you have all the
required
ID information before starting your program.
Be very VERY careful that your external program is solid and
can't get into something like an infinite loop, that just
doesn't
do good things to the database.
--
David A. Niblett | email: niblettda gru.net
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-----Original Message-----
From: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] On
Behalf Of Christian Michallek
Sent: Saturday, March 11, 2006 12:38 PM
To: DBMail mailinglist
Subject: [Dbmail] execute external program after mail insert
hi list.
im thinking about a way to execute an external script, after
a mail got
insert into the database.
because im using dbmail-smtp i was thinking about calling my
script
after dbmail-smtp got called.
my problem is that it would be best to know which mail got
insert so
having the message_idnr or unique_id would be good.
so im asking myself if theres a way to get this information
from
dbmail-smtp,
or perhaps someone knows another way to solve this problem.
greetings
christian
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|