[Zope] Get Column Names from SQL Query?

Casey Duncan cduncan@kaivo.com
Mon, 09 Apr 2001 15:44:44 -0600


"Thomas B. Passin" wrote:
> 
> Version 2.3.0
> 
> Casey Duncan wrote -
> 
> > "Thomas B. Passin" wrote:
> > >
> > > This is very slick, but - I hate to say it - it fails on my system.  I
> > > cut-and-pasted the code.  It throws a key error on "dictionaries".  Have
> you
> > > defined something clever elsewhere that supplies "dictionaries"?  I'd
> like
> > > this to work since my own code for doing it isn't quite as slick.
> > >
> > > Cheers,
> > >
> >
> > What version of Zope? This was tested against 2.3.1
> >
> 

A quick check of the 2.3.0 code shows support for "dictionaries" as part
of a sqlMethod's result class. My only other thought is that perhaps the
DA is overriding it somehow, although I doubt that is possible. Even
using a class to wrap the results (advanced tab of ZSQL method)
shouldn't affect this.

-- 
| Casey Duncan
| Kaivo, Inc.
| cduncan@kaivo.com
`------------------>