> 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.


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to