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

[Charlie Clark]

On 2003-02-03 at 16:47:24 [+0100], Stephan Herschel wrote:
> Hi group,
>=20
> 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
--=20
Charlie Clark
Helmholtzstr. 20
D=FCsseldorf
D- 40215
Tel: +49-211-938-5360