Thank you. That worked perfectly. Howard C. Shaw III Programmer/SysAdmin St. Thomas High School
---------- From: Jordan B. Baker[SMTP:jbb@spyderlab.com] Sent: Tuesday, April 20, 1999 11:54 AM To: Shaw, Howard Cc: 'Zope@zope.org' Subject: Re: [Zope] SQL Queries and Key Errors
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
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )