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> ?
You didn't tell what SQL-Database you use, but Postgres and Mysql allow logging/monitoring of the queries they get. So you are able to get the information straight before/while it hits the backend. cheers, oliver
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 )
participants (2)
-
Oliver Bleutgen -
Steve Spicklemire