Re: [Exim] problem with queries option

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Steffen Herold
CC: exim-users
Subject: Re: [Exim] problem with queries option
On Tue, 31 Jul 2001, Steffen Herold wrote:

>    queries = MYSQL_ALIAS : MYSQL_POSTMASTER


> MYSQL_ALIAS = SELECT MYSQL_ALIASUSERFIELD FROM MYSQL_ALIASTABLE WHERE
> MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_ALIASFIELD
> LIKE '${quote_mysql:$local_part}'
>
> MYSQL_POSTMASTER = SELECT MYSQL_ALIASUSERFIELD FROM MYSQL_ALIASTABLE
> WHERE_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_ALIASFIELD='*'


You have colons in your queries. These must be doubled. Macros are just
text substitutions at a low level.

-- 
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.