Re: [Exim] Got error 'empty (sub)expression' from regexp

Hi,

On Sun, Nov 23, 2003 at 02:38:01AM +0000, Daniel M. Drucker wrote:

>                    ${lookup mysql{SELECT value FROM userpref \
>                                   WHERE preference='whitelist_from' \
>                                   AND value rlike '${quote_mysql:${sender_address}}' } \
>                                   {$sender_address}}

This will create the following SQL:

        SELECT value FROM userpref
                WHERE preference='whitelist_from'
                AND value rlike 'address@???'

but 'address@???' should be a valid regexp pattern[1]. Maybe you
will get invalid sql-patterns for some sender addresses? You probably
should try '=' here?

        Chris

[1] http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html

--
Christian Vogel -- chris@???