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
_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to