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 )