[Zope] Column Names from SQL Query (was: Get Column Names from SQL Query?)

4 Apr 2001

      I remember posting this before, but something seems to have eaten it.
Laurie Nason nailed it for me, many thanks Laurie.

Here is a summary of the result:

Given a ZSQL query named "query1", this DTML will execute the query and
display a list of the column names:

  <dtml-let results=query1>
   <dtml-var "results.names()">
  </dtml-let>

And here it is using dtml-with:

<dtml-with query1>
   <dtml-var "names()">
</dtml-with>

Thanks to all for the help.

Regards,

Tom P

Thomas B. Passin