Scratch that! Finally worked it out:
condition = ${lookup mysql{MYSQL_AUTORESP}{yes}}
On another note, is it possible to set the "once (autoreply)" option to use
an MySQL table rather than a DBM file? On reading the spec I'm guessing "no"
at this point in time?
Ollie
> -----Original Message-----
> From: o.cook@??? [mailto:o.cook@etoncollege.org.uk]
> Sent: 01 October 2000 01:53
> To: exim-users@???
> Subject: [Exim] condition in director
>
>
> I'm trying to get a condition for a director to work as follows.
>
> 1) Do an SQL query.
> 2) If no rows are returned, don't run the director, or
> If one or more rows is returned, run the director.
>
> I'm using:
>
> condition = ${if {lookup mysql {MYSQL_AUTORESP}{$value}} {yes}{no}}
>
> where MYSQL_AUTORESP is:
>
> SELECT id FROM autoresponder WHERE address="${local_part}@${domain}"
>
> The error i'm getting is:
>
> marley:/usr/exim# sendmail -bt
> > ollie
> LOG: 0 MAIN PANIC DIE
> failed to expand condition"${if {lookup mysql {SELECT id FROM
> autoresponder WHERE
> address="${local_part}@${domain}"}{$value}} {yes}{no}}"
> for uservacation_director director: "lookup mysql {SELECT id FROM
> autoresponder WHERE address="ollie@???"" is
> not a number
>
> Would anyone be kind enough to point me in the correct
> direction. I had a
> look at the specification, but couldn't work this one out myself...
>
> Regards,
>
> Ollie
>
> --
> ## List details at
http://www.exim.org/mailman/listinfo/exim-users Exim details at
http://www.exim.org/ ##
