On Tue, 25 Feb 2003, Joe Lewis wrote:
> We've declared a domain list such as :
>
> domainlist local_domains = mysql;SELECT DISTINCT domain FROM \
> mail_domains WHERE mail_host='localhost'
You have fallen into a common trap of thinking that the syntax
"mysql;..." should return a list of domains. The syntax for that is
${lookup mysql{query}}
The "mysql;..." syntax is for checking that the current domain, when
used in a query, is successful. In effect, you are using the database as
an index. Since you have not mentioned $domain in your query, what you
have written isn't going to work.
I am planning to extend the explanation at the start of chapter 9 to try
to make this distinction more clear.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.