Sorry,
I got it working, I don't think the conversation between me and another
person got posted because I have a nasty habbit of forgetting to use 'reply-
all'.
All I had to do was add "AND domain='${domain}'" since the domainlist's are
all dynamically generated.
Philip Hazel said:
> On Sat, 20 Jul 2002 james@??? wrote:
>
>> # This doesn't work:
>> domainlist local_domains = \
>> ${lookup mysql {SELECT domain FROM domains \
>> WHERE type="local" }}
>
> *How* doesn't it work? Have you run tests with debugging? What was the
> output?
>
>> # This does:
>> domainlist local_domains = grickle.org : anti.grickle.org
>
> So, does the result of that lookup yield "grickle.org :
> anti.grickle.org"?
>
>> mysql> SELECT domain FROM domains
>> -> WHERE type="local";
>> +------------------+
>> | domain |
>> +------------------+
>> | grickle.org |
>> | anti.grickle.org |
>> +------------------+
>
> Looks like your lookup won't yield a colon separated list...
>
> Find out how the list is separated, then read about the $sg{ expansion
> item.
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
James Harr <james@???>
http://www.grickle.org
