Am 12.02.2014 12:01, schrieb Ritchie P. Fraser:
Hi Phil,
I don't think you were at all rude. In fact, you were consise and provided just
the answer I was looking for, and I thank you :-)
I had in the mean time been playing with....
condition = ${lookup pgsql{SELECT name FROM maildomains WHERE
name='$domain' AND status='t';}{yes}{no}}
...which, if a single match is returned from the database evaluates to true/yes
and if no rows returned is evaluated to false/no.
if you can get it too work that way, think different : let the database
do your job
condition = ${if eq{1}{${lookup pgsql{SELECT '1' FROM maildomains WHERE
name='${quote_mysql:${domain}}' AND status='t' LIMIT 1;}}}{yes}{no}}
Does the following ...
A= selects '1' ( for true ) IF name = $domain
IF $A == 1 return yes
All you need to change is the ${domain} variable, put there what you need to
check it against.
You can even have RegExpression in your SQL if pgsql supports it, which is a
mighty weapon :)
best regards,
Marius
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
