Autor: Ian P. Christian Data: A: serge CC: exim-users Assumpte: Re: [exim] handling nulls in SQL lookups
Serge Demonchaux wrote: >> Other then hacking the SQL statement to return a 0 (which I've
>> previously done with MySQL, but can't get sqlite to play nice) - is
>> there something I'm missing to default the value to 0 when there's a null?
> In my "router":
>
> virtual_alias:
> <snip>
> data = ${lookup sqlite{/etc/exim/exim_CentralDB.sql \
> SELECT destination FROM aliases \
> WHERE origine='${local_part}@${domain}'}}
> <snip>
One of us is missing something here - I don't understand how that helps
solve my problem.
