Philip Hazel wrote:
> On Tue, 31 Jul 2001, Steffen Herold wrote:
>
> > 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}'
>
> But you haven't. There are just single colons there.
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
Yes, I have tried this version too, but so every lookup will fail.
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='*'
virtual_alias director: mysql query=SELECT users FROM aliases WHERE domain
LIKE ':domain.com' AND alias LIKE ':failover' : SELECT users FROM aliases
WHERE_DOMAINFIELD LIKE ':domain.com' AND alias='*'
virtual_alias director deferred failover
message: search_find deferred: MYSQL: query failed: You have an error in
your SQL syntax near ''' at line 1
failover@??? cannot be resolved at this time:
search_find deferred: MYSQL: query failed: You have an error in your SQL
syntax near ''' at line 1
