[Zope] "SQL used:" FOUND

[Schmidt, Allen J.]

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 )