Yep! of course, great! thanks a lot for the info! cheers Andy.
----- Original Message ----- From: "Phil Pennock" <[EMAIL PROTECTED]> To: "Andy Smith" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Sunday, September 28, 2008 2:14 PM Subject: Re: [exim] which config file is being read? > On 2008-09-28 at 14:01 +0100, Andy Smith wrote: >> 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? > > You still need the quotes for MySQL itself as the delimiters; > quote_mysql provides the escaping but not the surrounding quotes. > > So: > > ${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')}} > > Search spec.txt for "external_smtp_batv" (without quotes) to see one > example of this. Search for the line starting "login:" (without quotes) > to see an example of why the delimiters themselves aren't provided, in > the LDAP example where the escaped data forms only a smaller part of the > entire query string: > user="cn=${quote_ldap_dn:$auth1},ou=people,o=example.org" > > -Phil > -- ## 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/
