John W. Baxter wrote:
> It would indeed be nice to be able to produce arbitrary queries within
> Exim (not just for MySQL although that's the one we use).
Um... the exim spec doesn't limit queries to SELECTs and say you have to
use the results of a query, so something like this works perfectly
(directly copied from my greylisting howto):
condition = ${lookup sqlite {GREY_DB \
insert into greylist (host, sender, rcpt, created, updated) \
values ('${quote_sqlite:$sender_host_address}', \
'${quote_sqlite:$sender_address}', \
'${quote_sqlite:[EMAIL PROTECTED]', \
$tod_epoch, $tod_epoch)} {1}{1}}
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
