Re: [exim] Using MySQL "INSTR" function fails exim-4.62

Etusivu
Poista viesti
Vastaa
Lähettäjä: Tony Finch
Päiväys:  
Vastaanottaja: Matt Judge
Kopio: exim-users
Aihe: Re: [exim] Using MySQL "INSTR" function fails exim-4.62
On Wed, 14 Jun 2006, Matt Judge wrote:
>
>  >>> processing "accept"
>  >>> check condition = ${if eq{${lookup mysql{SELECT 1 FROM domain_whitelist WHERE INSTR('test@???', 'google')}}}{1} {1}{0}}
>  >>>                 = 0
>  >>> accept: condition test failed


${lookup has ${if functionality built in, so try simply

condition = ${lookup mysql{SELECT 1 FROM domain_whitelist WHERE INSTR('test@???', 'google')} }

(You might be having problems with extra whitespace, maybe. Try running
with -d+all-memory.)

Tony.
--
<fanf@???> <dot@???> http://dotat.at/ ${sg{\N${sg{\
N\}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}\
\N}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}