Re: [Exim] lookup senders

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Markus Bengts
日付:  
To: exim-users
題目: Re: [Exim] lookup senders
>I am trying to set up mailing lists with two routers. This works fine if
>the
>sql queries return only one row, but it will not work when the queries
>return multiple rows.


That is how it is meant to be (I think). You can use the
$sender_address variable to lookup only one row.

>--------------------------------
>list_post:
>  driver = redirect
>  domains = lists.qvd.fi
>  senders = ${lookup pgsql \
>    {select email \
>      from person, qvdmember, district \
>      where person.pnbr = qvdmember.pnbr      and qvdmember.dnbr =
>district.dnbr \
>      and district.listname like '${quote_pgsql:$local_part}' \


and email = '${quote_pgsql:$sender_address}' \

>      and person.pnbr in \
>      (select pnbr from skill where skill = 'email')} \
>    {$value}}


# here it is ok to lookup multiple rows:
>  data = ${lookup pgsql \
>    {select email \
>      from person, qvdmember, district \
>      where person.pnbr = qvdmember.pnbr \
>      and qvdmember.dnbr = district.dnbr \
>      and district.listname like '${quote_pgsql:$local_part}' \
>      and person.pnbr in      (select pnbr from skill where skill =
>'email')} \
>    {$value}}
>  forbid_pipe
>  forbid_file
>  skip_syntax_errors
>  syntax_errors_to = mabengts@???
>  no_more

>


>Then I have one more question. How can I add one more sender address and
>reciever to all lists without having this address in the database?
>


You probably have to put it in the database and modify your queries.

>-- Markus
>


_________________________________________________________________
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.
http://join.msn.com/?PAGE=features/es