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