[Zope] strange behaviour of ZSQL methods

[Steve Spicklemire]

How about:

<dtml-var "theQuery(REQUEST=REQUEST, src__=1)">

-steve

>>>>> "Oliver" == Oliver Bleutgen <myzope@gmx.net> writes:

    >> Hi listies,

    >> something strange is happening with my ZSQL methods. I have a
    >> huge query that works great when testing it in the
    >> management-interface - it returns about 10 records or so.  but
    >> when I implement it into a dtml-method getting the parameters
    >> via X-Y-GMX: $flush REQUEST as usual, I am getting the whole
    >> database in return.  I'm quite sure that it's my own fault, so
    >> I'd like to see the translated SQL-query in the dtml-method to
    >> check for the wrong fields. Is there a tag for it like:
    >> <dtml-var MyZSQLQuery showRenderedSQLsource> ?

    Oliver> You didn't tell what SQL-Database you use, but Postgres
    Oliver> and Mysql allow logging/monitoring of the queries they
    Oliver> get. So you are able to get the information straight
    Oliver> before/while it hits the backend.

    Oliver> cheers, oliver

    Oliver> _______________________________________________ Zope
    Oliver> maillist - Zope@zope.org
    Oliver> http://lists.zope.org/mailman/listinfo/zope ** No cross
    Oliver> posts or HTML encoding!  ** (Related lists -
    Oliver> http://lists.zope.org/mailman/listinfo/zope-announce
    Oliver> http://lists.zope.org/mailman/listinfo/zope-dev )