Re: [exim] handling nulls in SQL lookups

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Ian P. Christian
Ημερομηνία:  
Προς: serge
Υ/ο: exim-users
Αντικείμενο: 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.

Thanks,

--
Ian P. Christian ~ http://pookey.co.uk