On Fri, 25 Oct 2002, Steve wrote:
> > domainlist local_domains @:localhost:mysql;select 1 from local_domains \
> > where domain='${quote_mysql:$domain}'
>
>
> Ah... the following works fine!
>
> domainlist local_domains = @:localhost:${lookup mysql{select domain from
> local_domains where domain='${quote_mysql:$domain}'}}
You should use the mysql;-style for this ;)
> ok... another question, I have a table of E-Mail addresses that I need to
> bounce (Which also does not work).
>
> In my acl_check_rcpt: section I have the following line...
>
> deny senders = ${lookup mysql {SELECT target FROM bounce}}
>
> I assume here that I will also need to change the query so that only one
> item is returned?
> Sort of like (Only I'm not sure what to use for $sender)...
>
> deny senders = ${lookup mysql {SELECT target FROM bounce WHERE
> target='${quote_mysql:$sender}'}}
