Hi Andreas, Sure.. <dtml-let theResult=sqlQuery> <dtml-var "theResult.names()" html_quote> </dtml-let> -steve
"Andreas" == Andreas Tille <tillea@rki.de> writes:
Andreas> On Wed, 21 Mar 2001, Steve Spicklemire wrote: >> you might also try just: >> >> <dtml-var MenuItem> Andreas> Thanks for your hints. I tried both (i.Menuitem, Andreas> MenuItem and also i.MenuItem). The usage of <dtml-var Andreas> Menuitem> seemed me the best because this is the exact Andreas> spelling when I use the database connection query test. Andreas> The column was just named Menuitem regardingless the fact Andreas> that it is spelled MenuItem in the SQL statement (OK, Andreas> column names in PostgreSQL are case insensitive - why Andreas> should they be in Zope??). Moreover there was no table Andreas> prefix in the test-output. Andreas> I wonder if there is an internal object which contains Andreas> all valid column names I could query. One more idea: If Andreas> I test the query I have to go through an extra screen Andreas> where I have to commit that "This query requires no Andreas> input." Could this cause any problem? >> good luck! Andreas> Thanks for the hints Andreas> Andreas. Andreas> _______________________________________________ Zope Andreas> maillist - Zope@zope.org Andreas> http://lists.zope.org/mailman/listinfo/zope ** No cross Andreas> posts or HTML encoding! ** (Related lists - Andreas> http://lists.zope.org/mailman/listinfo/zope-announce Andreas> http://lists.zope.org/mailman/listinfo/zope-dev )