[Zope] Get Column Names from SQL Query?

Thomas B. Passin tpassin@mitretek.org
Mon, 9 Apr 2001 15:58:03 -0400


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>
>