[ZCM] [ZC] 1745/ 3 Comment "Z SQL error KeyError Query"

[Collector: Zope Bugs, Features, and Patches ...]

Issue #1745 Update (Comment) "Z SQL error KeyError Query"
 Status Pending, Zope/bug medium
To followup, visit:
  http://www.zope.org/Collectors/Zope/1745

==============================================================
= Comment - Entry #3 by efge on Apr 4, 2005 9:00 pm

Also, python 2.4.1 is totally unsupported, use python 2.3.5.
________________________________________
= Comment - Entry #2 by efge on Apr 4, 2005 9:00 pm

That's not very clear. What *exact* query and paramters are you using?

________________________________________
= Request - Entry #1 by Anonymous User on Apr 4, 2005 8:50 pm

Steps:
add Z Mysql connection or Z Gladfly database connection.
test the connection is ok with select query / create query.

add Z SQL Method
In the Query template; is type a select Query and Save and Test; go error. Create query seems to be fine.

Site Error
An error was encountered while publishing this resource.
Error Type: KeyError
Error Value: 'query'

The error log file is:
Time  	2005/04/05 12:49:41.559 GMT+12
User Name (User Id) 	ppc (ppc)
Request URL 	http://10.0.44.12:8080/testcps/manage_test
Exception Type 	KeyError
Exception Value 	'query'

Traceback (innermost last):

    * Module ZPublisher.Publish, line 101, in publish
    * Module ZPublisher.mapply, line 88, in mapply
    * Module ZPublisher.Publish, line 39, in call_object
    * Module Shared.DC.ZRDB.DA, line 337, in manage_test
    * Module DocumentTemplate.DT_String, line 474, in __call__
    * Module DocumentTemplate.DT_In, line 602, in renderwb
    * Module DocumentTemplate.DT_Var, line 219, in render

KeyError: 'query'




==============================================================