On Tue, 30 Apr 2002, Colin Morey wrote:
> ${lookup mysql{select upasswd from db1.table1 where email='$1'} {$value} \
> {${lookup mysql{select upasswd from db1.table2 where domain='$1'} {$value} \
> { ${lookup mysql{select password from db2.table1 where user='$1'} {$value}
> fail}}}}} "
> which returns a valid lookup,
> "lookup yielded: 123456"
Well, is that what you expect it to yield?
> but reports -
> "Authentication failed for (fern.vianetworks.co.uk) [195.102.252.191]: 535
> Incorrect authentication data"
Does the user match that password?
> ${lookup mysql{select password from db2.table1md5 where user='$1'}
....This point is where { is missing....
> ${if or \
But I think this is a red herring. The way you did it above should work.
You don't need separate "if"s with lookups; they are already
conditionals.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
