[exim] help for exim sql tables

Top Page
Delete this message
Reply to this message
Author: Chen Guoqiang
Date:  
To: exim-users
Subject: [exim] help for exim sql tables
hi,

i used to have a sqlite database like this, which forward mails to
axinchan@???, demo@???,cn and test@??? when the
recipient is axinhust@???. it works fine.

--------------------------------------------------------------------------------------------------
sqlite> select * from alias;
axinhust|syan.com.cn|axinchan@???|01/04/2008
axinhust|syan.com.cn|demo@???|01/04/2008
axinhust|syan.com.cn|test@???|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|axinchan@??? : demo@??? :
test@???|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