> 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
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )