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 } }
The result of this is:
2010-09-09 02:43:19 DEBUG: active=1 frequency=2 ea=BLAH
email_autoresponder=BOBOBOBOBO
But it _SHOULD_ be:
2010-09-09 02:43:19 DEBUG: active=1 frequency=2 subject=BLAH message=BOBOBOBOBO
Can anybody tell me why "ea" and "email_autoresponder" are the last
two field names instead of "subject" and "message"?
Even weirder, if I remove the "AS ea" part from the initial FROM, then
adjust the query accordingly, the lookup results in:
2010-09-09 02:35:58 DEBUG: active=1 frequency=2
email_autoresponder=BLAH email_autoresponder=BOBOBOBOBO
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
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
