Philip Hazel wrote:
> 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.
I' ve read this before, but even when I use "::"
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='*'
I got this failure:
search_find deferred: MYSQL: query failed: You have an error in your SQL
syntax near 'LIKE '' at line 1
Steffen
