On Wed, 3 Jul 2002, yammy wrote:
> condition = "${if eq {${lookup mysql {select status from MX_email
> where email=${quote_mysql:\@${domain}} or
> email=${quote_mysql:${local_part}\@${domain}} order by email desc limit
> 1}}}{active} {1}{0}}"
> temporarily rejected RCPT <a.biehl@???>: MYSQL: query failed: You
> have an error in your SQL syntax near '@pulsaar.de order by email desc
> limit 1' at line 1
I am not a MySQL expert, but don't you need to use quotes in things like
"where xxx='yyy'" ?
^ ^
^ ^
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
