On Sunday 23 July 2006 11:03, Jakob Hirsch took the opportunity to write:
> Quoting Ian P. Christian:
> > set acl_m3 = ${lookup sqlite {SQLITE_DB SPAM_COUNT}{$value}}
> > However, this will obviously return nothing if the host has never mailed
> > before, and the 'Spam total' reports as NULL.
>
> set acl_m3 = ${lookup sqlite {SQLITE_DB SPAM_COUNT}{$value}{0}}
>
> Will return 0 if the lookup returns nothing.
If the lookup returns no records, that is. This lookup returns one record with
one column with a NULL value.
--
Magnus Holmgren [EMAIL PROTECTED]
(No Cc of list mail needed, thanks)
pgpJ2LKJOsCUP.pgp
Description: PGP signature
-- ## 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/
