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