Re: [exim] handling nulls in SQL lookups

Ian P. Christian wrote:
> However, this will obviously return nothing if the host has never mailed
> before, and the 'Spam total' reports as NULL
>

I'm not sure about sqlite but postgres has a function called
"COALESCE"[0] which can be used to remove nulls from results. Perhaps
sqlite has something similar.

-- 
Martin A. Brooks |  http://www.antibodymx.net/ | Anti-spam & anti-virus
   Consultant    |  martin@???      | filtering. Inoculate
 antibodymx.net  |  m: +447896578023           | your mail system.

[0] http://www.postgresql.org/docs/8.1/static/functions-conditional.html#AEN12639