On Wed, 21 Mar 2001, Steve Spicklemire wrote:
you might also try just:
<dtml-var MenuItem> Thanks for your hints. I tried both (i.Menuitem, MenuItem and also i.MenuItem). The usage of <dtml-var Menuitem> seemed me the best because this is the exact spelling when I use the database connection query test. The column was just named Menuitem regardingless the fact that it is spelled MenuItem in the SQL statement (OK, column names in PostgreSQL are case insensitive - why should they be in Zope??). Moreover there was no table prefix in the test-output.
I wonder if there is an internal object which contains all valid column names I could query. One more idea: If I test the query I have to go through an extra screen where I have to commit that "This query requires no input." Could this cause any problem?
good luck! Thanks for the hints
Andreas.