I found it! A quick Google search using: zope zsql show query http://lists.zope.org/pipermail/zope-db/2002-April/000512.html http://www.zope.org/Members/Zen/tips/GeneratedSQLSource Quick answer: <dtml-var "myzsqlmethod(REQUEST,src__=1)" html_quote> Allen -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Colyn Brown Sent: Thursday, December 12, 2002 12:32 PM To: Meilicke, Scott; zope@zope.org Subject: Re: [Zope] "SQL used:" I'm sorry, but I guess I wasn't descriptive enough. I'm talking about how Zope will print "SQL used:" at the bottom of the query result (inside the ZMI). It prints out what your query looks like without any DTML, if you're query uses DTML. I want to be able to get that outside the ZMI somehow. --colyn
From: "Meilicke, Scott" <scott.meilicke@intp.com> Date: Thu, 12 Dec 2002 09:28:14 -0800 To: 'Colyn Brown' <colyn.brown@newtimes.com>, zope@zope.org Subject: RE: [Zope] "SQL used:"
Begin by adding a Z Search Interface from the ZMI, add both the search and report forms. That will generate an interface to the zSQL method, in either zpt or dtml, which you can then modify to suit your needs.
Scott
-----Original Message----- From: Colyn Brown [mailto:colyn.brown@newtimes.com] Sent: Thursday, December 12, 2002 9:00 AM To: zope@zope.org Subject: [Zope] "SQL used:"
I have a SQL method that is pretty heavily conditioned. When I test the method in the ZMI, I get the query results and a display of the rendered query. How can I duplicate that outside the ZMI? Thanks.
--colyn
_______________________________________________ Zope maillist - Zope@zope.org 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 ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.
_______________________________________________ Zope maillist - Zope@zope.org 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 )