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 )