Re: [Exim] Databases + Exim

Góra strony
Delete this message
Reply to this message
Autor: Odhiambo G. Washington
Data:  
Dla: exim-users
CC: ssmeenk
Temat: Re: [Exim] Databases + Exim
* Sander Smeenk <ssmeenk@???> [20020820 15:31]: wrote:
> Quoting Odhiambo G. Washington (wash@???):
>
> > > |     ${lookup pgsql{select name from exim_local_domains}{$value}}
> > cipher.lin-gen.com : ${lookup pgsql{select name from
> > exim_local_domains where name = '$domain'}}

>
> Was I really stupid that I couldn't find this myself?
> I mean, where did you find you can use '$domain' in this context?


It was in the CHANGELOG for Exim-4. In Exim-3.x we used the "$key" instead.

Now I am told you should add "limit 1" to that query. I am a MySQL newbie
, but I guess they mean

${lookup pgsql{select name from exim_local_domains where name = '$domain' "limit 1"}}

Is that correct???




-Wash

S y s t e m s A d m i n i s t r a t o r
--

------=====================================------
Odhiambo Washington        Wananchi Online Ltd
E: WASH@???        www.wananchi.com
P: (+254)2 313 985-9        1st Floor Loita Hse
F: (+254)2 313 922        Loita St., NAIROBI
------=====================================------
++
"If dolphins are so smart, why did Flipper work for television?"