Re: [Exim] local domains from mysql db

I don't really know what your problem is because :

local_domains mydomain.com:mysql;SELECT domain FROM domains where
domain='$key';

works perfectly here

EG

> > On 2002-03-25 at 02:25 -0000, exim wrote:
> > > > "select domain_name from domains;" will return how many rows from
this
> > > > little database?
> > > >
> > > > Hint: answer != 1
> > > </phill>
> > >
> > > True, but when you do "lsearch;/usr/exim/aliases/domains" the answer
is
> also
> > > != 1 isn't it?
> >
> > lsearch is completely internal to Exim. Exim knows how to construct the
> > query. Exim knows how to do "The Right Thing". It supplies an implicit
> > key for the search.
> >
> > Mutating SQL queries to try to do The Right Thing is almost certainly
> > The Wrong Thing, The Frigging Stupid Thing, the I Just Spent How Many
> > Hours Debugging Something Which Was Silently Changed????? Thing, and
> > many others.
> >
> > > I tried that ("mysql;select domain_name where domain_name =
'$domain';")
> but
> > > that didn't work...
> >
> > Where are you selecting from?
>
> Sorry I wrote it in the message wrong, hmmm..... I don't know, I suppose
> I'll just have to
> keep trying different things then.
>
> Cheers for your help anyway,
>
> Gareth
> gjd@???
>
>
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##
>
>