Michael Bordignon wrote:
if ${lookup mysql {SELECT COUNT(*) FROM addresses WHERE email LIKE
However, it merely returns
Filter error: unrecognized condition word mysql near line 10 of
filter file
Try surrounding the lookup with double quotes: ${lookup mysql ...}
Oh, and please honour
Jakob Hirsch wrote on 15/03/2006 12:30 AM:
However, it merely returns
Filter error: unrecognized condition word mysql near line 10 of
filter file
Try surrounding the lookup with double quotes: ${lookup mysql ...}
Works perfectly. Thank you so much.
Michael
--
## List details at
Jakob Hirsch wrote on 9/03/2006 12:14 AM:
you don't need to fiddle in ACLs (and it wouldn't work with that, anyway).
LIKE '$sender_address'
if acl_m9 contains 1 then
That would be $acl_m9. But as said, it's not needed. Just use
if ${lookup mysql {SELECT COUNT(*)...}} is above 1
...
Michael Bordignon wrote:
Hi there,
I'm trying to have exim look at the sender address for all incoming
mail, if it matches more than one row (via a mysql query) then prepend
the subject with 'foo'.
I've come this far;
--
set acl_m9 = mysql;SELECT COUNT(*) FROM prospect_addresses WHERE
Jeremy Harris wrote:
warn
set acl_m9 = ${lookup mysql{stuff} {$value}}
{$value} is not necessary here.
if acl_m9 contains 1 then
That isn't acl syntax either. Perhaps
No, but filter syntax (same as below).
Perhaps you should buy the book.
It's all in the spec.
--
## List details at
Michael Bordignon wrote:
I'm trying to have exim look at the sender address for all incoming
mail, if it matches more than one row (via a mysql query) then prepend
the subject with 'foo'.
I've come this far;
--
set acl_m9 = mysql;SELECT COUNT(*) FROM prospect_addresses WHERE email
you
Hi there,
I'm trying to have exim look at the sender address for all incoming
mail, if it matches more than one row (via a mysql query) then prepend
the subject with 'foo'.
I've come this far;
--
set acl_m9 = mysql;SELECT COUNT(*) FROM prospect_addresses WHERE email
LIKE '$sender_address'