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:${local_part}@${domain}}', \
$tod_epoch, $tod_epoch)} {1}{1}}