[Zope] Get Column Names from SQL Query?

Thomas B. Passin tpassin@mitretek.org
Wed, 4 Apr 2001 11:50:51 -0400


I want to run an SQL query, like

select * from person

Then I want to extract the column names from the returned data.  In other
words, I don't want to hand-code them into the result page.

I know how to do this in Cold Fusion, but I don't know how in Zope.

I'm using a ZSQL method, of course, to query the database.

Anyone know how to do this without running an external method?

Tom P