Hi all, I'm running exim 4.69. I have the following query:
AUTORESPONDER_DATA = ${lookup mysql {SELECT
ea.active,ea.frequency,ea.subject,ea.message FROM email_autoresponder
AS ea JOIN email AS e ON e.autoresponder_id=ea.id JOIN domain AS d ON
d.id=e.domain_id WHERE e.name='${quote_mysql:${local_part}}' AND
d.name='${quote_mysql:${domain}}' AND e.active=1 } }
Which of course cannot work. Is it my choice of field names causing
the problem? "message" and "subject" seem dangerously close to
reserved keywords, so it's plausible to me.
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius