[Zope] Get Column Names from SQL Query?

[Thomas B. Passin]

This is very slick, but - I hate to say it - it fails on my system.  I
cut-and-pasted the code.  It throws a key error on "dictionaries".  Have you
defined something clever elsewhere that supplies "dictionaries"?  I'd like
this to work since my own code for doing it isn't quite as slick.

Cheers,

Tom P

Casey Duncan wrote -

>
> Here is some tested DTML code to create an HTML table from any given SQL
> query:
>
> <table border="1">
> <dtml-with name="sqlMethod">
>     <tr>
>     <dtml-in name="names">
>         <th>&dtml-sequence-item;</th>
>     </dtml-in>
>     </tr>
>     <dtml-in name="dictionaries">
>         <tr>
>         <dtml-in name="values">
>             <td>&dtml-sequence-item;</td>
>         </dtml-in>
>         </tr>
>     </dtml-in>
> </dtml-with>
> </table>
>