26 Apr
2001
26 Apr
'01
8:44 p.m.
Jan Kubatzki asked
how can i find out the field names of a table of a database ?
If you mean "how can my Zope code find out the column names of a table?", it was covered on the list a week or two ago. Here is a summary of how I suggested doing it (after some good help from the list): 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> Tom P