* on the Mon, Feb 26, 2007 at 03:37:09PM +0000, #Ronan McGlue wrote:
> My redirect router looks like
>
>
> data = ${lookup mysql{select mailbox,host from routing where alias =
> '${quote_mysql:$local_part}'}}
>
> according to the spec this will return
>
> mailbox=testuser host=testhost.qub.ac.uk
>
> how do i change this to be [EMAIL PROTECTED] ?
Do it in the query it's self:
data = ${lookup mysql{select concat(mailbox,'@',host) from routing where alias
= '${quote_mysql:$local_part}'}}
That will return "[EMAIL PROTECTED]" rather than
"mailbox=testuser host=testhost.qub.ac.uk" as the result is a single
value, rather than a list.
Mike
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
