[Zope-DB] ZSQL Result Set: How to find out column's names?

Charlie Clark charlie@begeistert.org
Mon, 03 Feb 2003 16:53:54 +0100

On 2003-02-03 at 16:47:24 [+0100], Stephan Herschel wrote:
> Hi group,
> I'm testing a ZSQL Method which uses a dynamically constructed=20
> sql-statement. Thus i don't know the column names of the result set.

I don't see that that has to be the case but anyway

> How can I get the column names to display them in a dtml-method?

Use a PythonScript and get at the the results.data_dictonary()

and use ZPT instead of DTML ;-)

Charlie Clark
Helmholtzstr. 20
D- 40215
Tel: +49-211-938-5360