*Thank you* Philip.
Tomer.
Philip Hazel wrote:
> On Tue, 8 Aug 2006, Tomer Horn wrote:
>
>
>> client_send = ${lookup mysql{select
>> concat('^',users_manualroute.user,'^',users_manualroute.passwd) \
>> from users_manualroute,users,domains \
>> where
>> concat(users.user,'@',domains.domain)='${quote_mysql:$authenticated_id}' \
>> and users.domain_id=domains.id \
>> and users.active='on' and domains.active='on' \
>> and users_manualroute.host LIKE '%.%'}}
>>
>
> You need to double the colon after quote_mysql because client_send is a
> *list* of strings to send.
>
>
>> (0): expansion of "${lookup mysql{select
>> concat('^',users_manualroute.user,'^',users_manualroute.passwd) from
>> users_manualroute,users,domains where
>> concat(users.user,'@',domains.domain)='${quote_mysql" failed in plain
>>
>
> There is the clue ... note that it has chopped the string that it is
> trying to expand at the colon.
>
>
