Re: [Exim] Condition for Exiscan?

At 03:07 PM 12/30/2002 +0100, Jan Johansson wrote:
>Shouldnt the following work?
>
>${lookup mysql{select VirusCheckIn from \
> pm_users, pm_domains where pm_users.SiteID=pm_domains.ID \
> AND pm_users.Name='$local_part' AND pm_domains.Name='$domain' \
> AND VirusCheckIn = 'true'}{1}{0}}
>
>Yet, when running debug i see
>
>18396 type=mysql key="select VirusCheckIn from pm_users, pm_domains
>where pm_users.SiteID=pm_domains.ID AND pm_users.Name='' AND
>pm_domains.Name='' AND VirusCheckIn = 'true'"
>18396 database lookup required for select VirusCheckIn from pm_users,
>pm_domains where pm_users.SiteID=pm_domains.ID AND pm_users.Name='' AND
>pm_domains.Name='' AND VirusCheckIn = 'true'
>18396 MYSQL query: select VirusCheckIn from pm_users, pm_domains where
>pm_users.SiteID=pm_domains.ID AND pm_users.Name='' AND
>pm_domains.Name='' AND VirusCheckIn = 'true'
>18396 MYSQL new connection: host=localhost port=0 socket=NULL
>database=xams user=xams
>18396 MYSQL: no data found
>
>Does this mean that those variables aren't available to Exiscan? Or am I
>screwing something else up?

Hmm...what does a select query give you as result?

mysql> select VirusCheckIn from \
pm_users, pm_domains where pm_users.SiteID=pm_domains.ID \
AND pm_users.Name='username' AND pm_domains.Name='domainname' \
AND VirusCheckIn = 'true'}{1}{0}}

The error is self explanatory, IMHO. "18396 MYSQL: no data found"

-Kevin