20 Apr
1999
20 Apr
'99
4:54 p.m.
On Tue, 20 Apr 1999, Shaw, Howard wrote:
This same query works perfectly under myadmin2.0 against the same database. Any ideas why it fails here? I thought it might be because 'valid' was a reserved word, but I seriously doubt that 'vald' is.
Error, exceptions.KeyError: unhandled
SQL used:
SELECT (PASSWORD('testing')=password) as vald FROM researchers WHERE uid='test'
This seems to be a bug somewhere in either the MySQL driver of the Zope glue. Try CONCAT(password-crap) to cast the result to a string automatically. Hopefully this will help you. :) ------- Jordan B. Baker -- jbb@spyderlab.com weaving the web @ http://www.spyderlab.com