Re: [Exim] problem with queries option

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Philip Hazel
Ημερομηνία:  
Προς: Steffen Herold
Υ/ο: exim-users
Αντικείμενο: 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.