Re: [exim] router condition, problem with "and"

Top Page
Delete this message
Reply to this message
Author: Jonas Forsberg
Date:  
To: exim-users
Subject: Re: [exim] router condition, problem with "and"
On Thu, 19 Aug 2010 14:33:08 +0300, Lena@??? wrote:
>> From: Jonas Forsberg
>
>> The condition consists of two parts:
>>
>> 1st a check in the Subject field after a string, that I have
>> got to work.
>>
>> condition = ${lookup mysql{ SELECT email FROM users
>> WHERE email='${quote_mysql:$local_part}@${quote_mysql:$domain}'}
>> {true}{false}}
>>
>> 2nd a check in a MySQL table, which I have been working.
>>
>> condition = ${if match{$h_subject:}{N^KalleKalas$N}{yes}{no}}
>>
>> but to combine those two into a
>> "and rule" makes my head spin.
>
>> From: Marcin Miros?aw
>
>> condition = ${if and{
>> {lookup mysql{SELECT 1 FROM users WHERE
>> email='${quote_mysql:$local_part}@${quote_mysql:$domain}'}}
>> {if match {$h_subject:}{N^KalleKalas$N}{yes}{no}}}
>> }
>
> Wrong because:
>
>> From: Odhiambo Washington
>
>>   ${if and {
>>            {cond1}
>>            {cond1}
>>            {cond3}
>>            ...
>>            }
>>            {truestring}{falsestring}}

>
> "lookup" is not a condition. You can use "eq" condition:
>
>  condition = ${if and{\
>    {eq{${lookup mysql{SELECT email FROM users \
>              WHERE
> email='${quote_mysql:$local_part}@${quote_mysql:$domain}'}\
>              {1}{0}}}\
>       {1}}\
>    {match{$h_subject:}{\N^KalleKalas$\N}}\
>               }}

>
> The "bool" condition allows to write this a little clearer, but
> it's implemented only in Exim 4.70 and later versions.


Thank you soooo much. That worked like a charm!
Although I now have to try to "decrypt" the condition so I understant
it :)

//Jonas