Hmm, unfortunately making this change has broken my exim. I see this mysql 
error as a result:

2008-09-28 13:55:14 [83097] 1Kjvnu-000LcD-6y == [EMAIL PROTECTED] 
R=virtual_forward defer (-1): failed to expand "${lookup mysql { select 
remote_name from forwarder left join domain_alias on 
domain_alias.domain_name = forwarder.domain_name where local_part = 
${quote_mysql:$local_part} and (forwarder.domain_name = '$domain' or alias = 
'$domain')  }}": lookup of "select remote_name from forwarder left join 
domain_alias on domain_alias.domain_name = forwarder.domain_name where 
local_part = a.smith and (forwarder.domain_name = 'ukgrid.net' or alias = 
'ukgrid.net')  " gave DEFER: MYSQL: query failed: Unknown column 'a.smith' 
in 'where clause'\n

I suppose its a result of the number of curly brackets used in the 
statement, but Im not sure how to write this properly. Any suggestions?

thanks a lot Andy. 


-- 
## 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/

Reply via email to