[Zope] how do I get field names from a query

how do I get the names of the fields returned from a SQL query ? ( I would like to generate stuff using the names automatically) I know they must be available because I can use them directly ! I've tried lots of alternatives of the form dtml-in "sqlListTable(table_name='personnel')" dtml-in

[Zope] Re: how do I get field names from a query

still trying to get field names from a query of the form SELECT * FROM MYTABLE dtml-in "sqlListTable(table_name='personnel')" dtml-in sequence-item Pdtml-var sequence_key /dtml-in doesnt seem to work niether does the How To http://www.zope.org/Members/teyc/howtoSQLVariables

[Zope] character encoding

Hi I am currently having problems sorting out utf8 encoding through the following chain of events, and I would GREATLY appreciate any help anyone can offer. I need to do the following, in a Zope 2.9.2-, python 2.4.3 setup (I have also tried this on Zope 2.10.4 with the uniocode patch for