On 17/09/15 08:14, Nick wrote: > I've a sqlite lookup which executes a query like this: > > select group_concat(recipients) from aliases where stem = "blah"; > > The problem is, when there are no matches, the result in exim is the string > "NULL". > > I see there is a config option in the sqlite command line client: > > .nullvalue STRING Print STRING in place of NULL values > > Is it possible to modify this setting in exim so that my lookups result in > ""?
Why not use an SQL coalesce(field, '') ? -- Cheers, Jeremy -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
