Sorry about that - I have all my queries in a directory called queries and the name of the query is qryreturnallusers. The bit you need is the .names() on the end of whatever query you are calling. HTH L %:-} -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Thomas B. Passin Sent: Wednesday, April 04, 2001 1:33 PM To: Zope Mailing List Subject: Re: [Zope] Get Column Names from SQL Query? Thanks, but neither of these work. What am I missing? [Casey Duncan]
I think you should be able to do something like this (untested):
<dtml-with name="sqlMethod"> <dtml-in name="dictionaries"> <dtml-in name="sequence-item" mapping> <dtml-var name="sequence-key">: <dtml-var name="sequence-item"><br /> </dtml-in> </dtml-in> </dtml-in>
My sql method has no attribute named "dictionaries", so this fails. What do you have, that you are calling "sqlMethod", that does have a dictionaries attribute? [Laurie Nason] <dtml-let Fields="queries.qryreturnallusers().names()"> <dtml-in Fields> <dtml-var sequence-item></p> </dtml-in> </dtml-let> I assume that your sqlMethod is called "queries". My sql method has no attribute (i.e., method) called qryreturnallusers, so this way fails too. How did you get a method with that name associated with your sql method? Thanks, Tom P _______________________________________________ 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 )