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 | [EMAIL PROTECTED] | filtering. Inoculate antibodymx.net | m: +447896578023 | your mail system. [0] http://www.postgresql.org/docs/8.1/static/functions-conditional.html#AEN12639 -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
