Surely if we're after setting relay domains and the table holds a list
of all of them............
Our query is just.....
Select * FROM Domains
we don't need a WHERE clause because we want them all anyway.....
Nige.
Philip Hazel wrote:
>
> On Thu, 13 Jul 2000, Nancy Pettigrew wrote:
>
> > Is this syntactically correct? (The Domains table just has a list of all
> > the domains to relay for...)
> >
> > relay_domains = ${lookup mysql{select Domain from Domains}{$value}fail}
>
> No. What you want is
>
> relay_domains = mysql;select Domain from Domains
>
> However, the query isn't right; it should be looking up the domain you
> are interested in. Try
>
> relay_domains = mysql;select Domain from Domains where Domain="$key"
>
> The value of $key is the name of the domain you are testing.
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
