You need an external method to get the dictionary object that has the field name to column number Here is the external method: --------------------------------- def doPySQL(self, zQry) : tvar1 = 'res=self.'+zQry exec tvar1 return res._schema.items() ------------------------------------------ Here is a dtml document that uses the external method: (getRes is what I call the external method in Zope) This was for proof of idea - it is not pretty ------------------------------------------------------------------- <html><head><title>Test</title></head><body> <dtml-with "_.namespace(t1=getRes('Your_Query_Here()'))"> <dtml-var "_.len(t1)"> Columns<br> <dtml-var "_.str(t1)" html_quote><br><br> <dtml-in t1> <dtml-var "_.str(_['sequence-key'])"> = <dtml-var "_.str(_['sequence-item'])"><br> </dtml-in> <br><br> </dtml-with> </body></html> </dtml-comment> <html><head><title>Test</title></head><body> <dtml-with "_.namespace(t1=Your_Query_Here(),t2=getRes('Your_Query_Here()'))"> <hr> <dtml-in t1> <dtml-in t2 sort=sequence-item> <dtml-var "_['sequence-key']"> = <dtml-var "_.getitem(_['sequence-key'])" html_quote><br> </dtml-in><hr> </dtml-in> </dtml-with> </body></html> --------------------------------------------------------------------------------- ----- Original Message ----- From: Curtis Maloney <curtis@umd.com.au> To: Adam Molyneaux <adam.molyneaux@epfl.ch> Cc: <zope@zope.org> Sent: Tuesday, May 30, 2000 11:31 PM Subject: Re: [Zope] how do I get field names from a query On Wed, 31 May 2000, Adam Molyneaux wrote:
how do I get the names of the fields returned from a SQL query ? ( I would like to generate stuff using the names automatically) I know they must be available because I can use them directly !
I've tried lots of alternatives of the form
<dtml-in "sqlListTable(table_name='personnel')"> <dtml-in sequence-item> <P><dtml-var sequence_item> </dtml-in >
Ok... someone may have already answered this, but here's my guess. (Yes, this is untried, sorry :) <dtml-in "sqlQueryBlah()"> <dtml-in sequence-item> <dtml-var sequence-key> = <dtml-var sequence-item> </dtml-in> </dtml-in>
which give me the values but not the names, and looked through lots of the old msgs.
I'm certain this was tackled some time in the past, but yeh, searching the list logs can sometime be suprisingly fruitless.
Thanks in advance if anyone can help
glad i could help. (o8
adam adam.molyneaux@epfl.ch
-- Have a better one, Curtis. <dtml-var standard_work_disclaimer> _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )