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

Top Page
Delete this message
Reply to this message
Author: Tony Finch
Date:  
To: Matt Judge
CC: exim-users
Subject: Re: [exim] Using MySQL "INSTR" function fails exim-4.62
On Wed, 14 Jun 2006, Matt Judge wrote:

> 17:58:23 48503 expanding: SELECT '1' FROM domain_whitelist AS b, vdomains AS v WHERE INSTR('${quote_mysql:$h_from:}', b.address)
> 17:58:23 48503    result: SELECT '1' FROM domain_whitelist AS b, vdomains AS v WHERE INSTR('', b.address)


You almost certainly want $sender_address not $h_from.

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}}