Re: [Exim] SQL and aliases.

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Nico Erfurth
Ημερομηνία:  
Προς: Eric Renfro
Υ/ο: exim-users@exim.org
Αντικείμενο: Re: [Exim] SQL and aliases.
On Mon, 21 Oct 2002, Eric Renfro wrote:

> sql_aliases:
> driver = redirect
> allow_fail
> allow_defer
> data = ${lookup pgsql {SELECT list,email FROM staticlists WHERE domain =
> '$domain'}}


This selects 2 fields, they will be both returned with ther name and an =
prepended, that's what you see in the logfile, use this instead
data = ${lookup pgsql {SELECT email FROM staticlists WHERE domain =
${quote_mysql:$domain}'}}

but i think you really want this
data = ${lookup pgsql {SELECT email FROM staticlists WHERE domain =
${quote_mysql:$domain} and list = {$quote_mysql:$local_part}'}}


ciao