On 03/03/2020 13:36, Sławomir Dworaczek via Exim-users wrote:
> uservacation:
> driver = accept
> domains = ${lookup mysql{SELECT domains.fqdn AS domain FROM domains,mailboxes,vacations WHERE \
> vacations.active=1 AND \
> vacations.mailbox_id=mailboxes.id AND \
> mailboxes.active=1 AND \
> mailboxes.local_part='${quote_mysql:$local_part}' AND \
> mailboxes.domain_id=domains.id AND \
> domains.active=1 AND \
> domains.fqdn='${quote_mysql:$domain}'}}
>
>
> it's possible add start date and end date autoreply ?
> eg. if current date > startdate and current date < stopdate
If you're wanting to do that as part of the mysql
lookup (which seems reasonable) then you're asking
in the wrong place; it's a mysql syntax problem.
--
Cheers,
Jeremy
