Phil so that you would know it would probably be easier to merge the tables
such as
select domain from domain_table where domain = '$key'
On 27 Aug 2001, at 11:38, Philip Hazel wrote:
Date sent: Mon, 27 Aug 2001 11:38:53 +0100 (BST)
From: Philip Hazel <ph10@???>
To: William X Walsh <william@???>
Copies to: <exim-users@???>
Subject: Re: [Exim] 2 mysql lookups in local_domains?
> On Sun, 26 Aug 2001, William X Walsh wrote:
>
> > Is this possible? My initial experiment (below) failed, everything
> > was lookup deferred.
> >
> > local_domains = elrond.dso.net:localhost:mysql;select domain_name from
> > domain where domain_name='$key':mysql;select domain_name from
> > other_domains where domain_name='$key'
>
> 1. Why did it defer? Did it give any clues? What you you get if you run
>
> exim -d9 -bt xxx@domain
>
> where domain is (or is not) in one or other of the tables?
>
> 2. I am not an SQL expert, but isn't there some way to write a single
> query that does this?
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
>
>
>
---
Jason Robertson
Network Analyst
jason@???
http://www.astroadvice.com
