[Zope] Help with general purpose ZSQL Method
   
    Jon Prettyman
     
    jprettyman@acm.org
       
    03 Nov 2000 15:03:59 -0800
    
    
  
I want to write a generic table browser ZSQL method and am having
trouble getting the output that I want.
Given a ZSQLMethod that looks like this:
ID:        browse_table
Arguments: table:string=""
Script:
SELECT * FROM <dtml-var table>
I'm trying to write a DTML method to display the results of this
method WITH COLUMN NAMES.  For the life of me, I can't figure out how
to do this.
Basically, I have:
<dtml-in "browse_table(table='xxxx')" size=1>
  <dtml-in sequence-item>
    <dtml-var sequence-item>
  </dtml-in>
</dtml-in>
The inner sequence-item gives me the data, but how to I determine the
column name?
-jon