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

[Adam Molyneaux]

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 sequence-item>
      <P><dtml-var sequence_item>
</dtml-in >


which give me the values but not the names, and looked through lots of the
old msgs.

Thanks in advance if anyone can help

adam
adam.molyneaux@epfl.ch