Yep! of course, great! thanks a lot for the info!
cheers Andy.
----- Original Message -----
From: "Phil Pennock" <exim-users@???>
To: "Andy Smith" <a.smith@???>
Cc: <exim-users@???>
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
>
