[Zope-dev] Showing the "SQL Used"

Evan Simpson evan@4-am.com
Thu, 06 Jan 2000 17:21:15 -0600


David Symons wrote:

> I have been trying to find the way to display the actual SQL query that has
> been run (in the same fashion as the "SQL Used" displayed while testing an
> SQL Method).

Call the SQL Method with exactly the same parameters/context, but add
src__=1.  For example:

<dtml-in expr="SQL_this(id=500)">...</dtml-in> --> <dtml-var
expr="SQL_this(id=500, src__=1)">

Cheers,

Evan @ 4-am