[Zope] SQL Queries and Key Errors

[Shaw, Howard]

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'




Traceback (innermost last):
  File lib/python/ZPublisher/Publish.py, line 877, in publish_module
  File lib/python/ZPublisher/Publish.py, line 590, in publish
    (Info: /genus/uber/checkpassdb/manage_test)
  File lib/python/Shared/DC/ZRDB/DA.py, line 305, in manage_test
    (Object: CopySource)
  File lib/python/Shared/DC/ZRDB/DA.py, line 286, in manage_test
    (Object: CopySource)
  File lib/python/Shared/DC/ZRDB/DA.py, line 390, in __call__
    (Object: CopySource)
  File /home/zope/lib/python/Products/ZMySQLDA/db.py, line 185, in query
KeyError: (see above)


Howard C. Shaw III
Programmer/SysAdmin
St. Thomas High School