Hello. 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). Can anyone help? TIA, David. -------------------------------------------------------- David Symons email: david_symons@hotmail.com Canberra, Australia The message below is inserted by the mail provider ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
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
participants (2)
-
David Symons -
Evan Simpson