[Zope] Re: Howto debug (Re: PostgreSQL Problem)

[Steve Spicklemire]

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 )