[Zope] Displaying SQL used???

Karl Putland kputland@wisen.com
Wed, 12 Jan 2000 09:45:25 -0700


This is a multi-part message in MIME format.

------=_NextPart_000_0079_01BF5CE1.C0682170
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

How would I go about showing the SQL used like the ZSQL method does at =
the bottom of the page?

<dtml-in sql_method1>
    <dtml-if sequence-start>
        <dtml-var SHOW_SQL_HERE>
        ...
    </dtml-if>
    ...
    ...
</dtml-in>

- Karl Putland
kputland@wisen.com

------=_NextPart_000_0079_01BF5CE1.C0682170
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>How would I go about showing the SQL=20
used&nbsp;</FONT><FONT face=3DArial size=3D2>like the ZSQL method does =
at the bottom=20
of the page?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;dtml-in =
sql_method1&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &lt;dtml-if=20
sequence-start&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&lt;dtml-var=20
SHOW_SQL_HERE&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;=20
...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; =
&lt;/dtml-if&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; ...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; ...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&lt;/dtml-in&gt;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>- Karl Putland</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>kputland@wisen.com</FONT></DIV></BODY></HTML>

------=_NextPart_000_0079_01BF5CE1.C0682170--