I may be incorrect.... but did you compile exim with mysql functionality ?
-----Original Message-----
From: me& [
mailto:exim-list@opbit.com]
Sent: 25 March 2002 02:53
To: Gareth Down; exim-users@???
Subject: 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/ ##
>
>
--
## List details at
http://www.exim.org/mailman/listinfo/exim-users Exim details at
http://www.exim.org/ ##
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or
taking of any action in reliance upon this information by persons or
entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not accept liability for any
personal views expressed in this message.
