Do another lookup - the lookup value(s) are cached for the last lookup
AFAIK.
--
Peter Galbavy
Knowledge Matters Ltd.
http://www.knowledge.com/
----- Original Message -----
From: "Ed Symanzik" <zik@???>
To: <exim-users@???>
Sent: Thursday, January 18, 2001 3:08 PM
Subject: [Exim] Using both fields of a multi-field lookup
> I want to use a single database lookup to retrieve both the
> uid and home directory.
>
> I can do this with:
>
> ${lookup mysql {SELECT DISTINCT uid,homedir FROM account
> WHERE username = '${quote_mysql:$local_part}'} {$value} fail}
>
> I can get the directory with extract like so:
>
> directory = ${extract{homedir}{lookup thing} fail}
>
> But, how do I get the uid without having to do another lookup?
>
> This:
>
> foo = ${lookup...
> directory = ${extract{homedir}{$foo} fail}
> user = ${extract{uid}{$foo} fail}
>
> doesn't work.
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at
http://www.exim.org/ ##
>
