Re: [exim-dev] sqlite lookup support.

Góra strony
Delete this message
Reply to this message
Autor: Jakob Hirsch
Data:  
Dla: exim-dev
Temat: Re: [exim-dev] sqlite lookup support.
Philip Hazel wrote:

> Instead of making it a rather odd "single-key" type lookup, I will make
> it into a true "query-style" lookup, with this syntax:
>
> ${lookup sqlite{/file/name <sql query>}}


That sounds quite sensible to me.

> Also, you didn't supply a quoting function. Is is correct that the only
> character that needs to be quoted (by doubling) is the single quote?


I will ask on the sqlite mailing list, but as far as I know (and
tested), yes. But only if the value is sourrended by single quotes. If
you use double quotes, then they (and only they) have to be quoted. So
the behaviour of the quoting function depends on the quotes. That's bad,
but I think it's ok to restrict it to single quotes and put a warning
into the spec. If somebody wants double quotes, he can still use ${sg.