Re: [exim] Lookup query

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Tony Finch
Ημερομηνία:  
Προς: Ben Whyte
Υ/ο: exim-users
Αντικείμενο: Re: [exim] Lookup query
On Thu, 22 Sep 2005, Ben Whyte wrote:

>                !senders = ${lookup mysql {MYSQL_Q_SENDER_VERIFY_SENDER}}

>
> The database table senders contains two records which match the criteria for
> sender_verify_sender
>
> refs-owner@??? and
> radium@???


The result of the mysql lookup is not in the correct format for an Exim
address list: each entry is separated by a newline, whereas it must be
separated by a colon. You can either use ${sg {\\s+}{:} or you can re-jig
the mysql query so that it is appropriate for use as a list item, e.g.
    !senders = mysql; ... stuff ...


Tony.
--
<fanf@???> <dot@???> http://dotat.at/ ${sg{\N${sg{\
N\}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}\
\N}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}