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

Top Page
Delete this message
Reply to this message
Author: Christian Vogel
Date:  
To: Daniel M. Drucker
CC: exim-users
Subject: 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@???