[Zope] SQL Queries and Key Errors

[Shaw, Howard]

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 )
>