Re: [Zope] How to show field names from sql query?

Thomas Apostolou wrote at 2005-9-19 13:43 +0100:

i use the following to get to show the results from an sql query. What are the expresions to show the field names?

The ZSQL method result has a method "names" returning the field names. You can use it in a "dtml-let", similar to: <dtml-let result="TestODBCEM(....)" field_names="result.names()"

<dtml-in result prefix=row> <dtml-in field_names prefix=field> <dtml-var field_item> <!-- the field name --> <dtml-var expr="_[field_item]"> <!-- its value --> .... -- Dieter