hi,
i used to have a sqlite database like this, which forward mails to
[EMAIL PROTECTED], [EMAIL PROTECTED],cn and [EMAIL PROTECTED] when the
recipient is [EMAIL PROTECTED] it works fine.
--------------------------------------------------------------------------------------------------
sqlite> select * from alias;
axinhust|syan.com.cn|[EMAIL PROTECTED]|01/04/2008
axinhust|syan.com.cn|[EMAIL PROTECTED]|01/04/2008
axinhust|syan.com.cn|[EMAIL PROTECTED]|01/04/2008
--------------------------------------------------------------------------------------------------
and the way to lookup the records:
data = ${lookup sqlite{SQLITE_DB SELECT sendto FROM alias WHERE \
( username='${quote_sqlite:$local_part}' AND (domain=
'${quote_sqlite:$domain}') ) \
} }
but now i'd like the database to be like below:
--------------------------------------------------------------------------------------------------
sqlite> select * from alias;
axinhust|syan.com.cn|[EMAIL PROTECTED] : [EMAIL PROTECTED] :
[EMAIL PROTECTED]|01/04/2008
--------------------------------------------------------------------------------------------------
and then lookup the table
data = ${lookup sqlite{SQLITE_DB SELECT sendto FROM alias WHERE \
( username='${quote_sqlite:$local_part}' AND (domain=
'${quote_sqlite:$domain}') ) \
} }
it doesn't work,can anybody tell me why and the way to lookup the database
in "data = ".
thanks
axinchan
2008/01/22
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
