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}}
