[egenix-users] mxodbc_zope_da_1.0.9 problem: KeyError, query

[Charlie Clark]

On 2005-05-05 at 14:37:42 [+0200], RJ Juneau <rj at maxxian.com> wrote:
> 
> 
> More interesting info on the problem:
> 
> If I execute the query directly in the "test" window of the base eGenix
> mxODBC Database Connection window, it works fine and returns the 20
> lines expected. That could point to a problem in the rendering, which
> seems to be where the traceback ends.
> 
> Note that within the same Zope system I also have an ODBC connection to
> a Sybase database, and I have successfully tested multi-line ZSQL
> queries there.
> 
> This is the traceback:
> 
>     Time    2005/05/05 07:55:15.294 GMT-4    
> 
>     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'

This is definitely a problem in your DTML or some other part of Zope. Zope 
is raising a KeyError which means something is missing from a mapping. Are 
you trying to display the query itself?

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::