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.