[ZCM] [ZC] 1322/ 1 Request "ZSQL testing "

[Collector: Zope Bugs, Features, and Patches ...]

Issue #1322 Update (Request) "ZSQL testing "
 Status Pending, Zope/bug low
To followup, visit:
  http://collector.zope.org/Zope/1322

==============================================================
= Request - Entry #1 by rjmunro on May 7, 2004 12:47 pm

When testing a Z SQL method, the SQL that was used is quoted back to you, after the DTML is processed. This SQL is not HTML quoted. The fix is quite simple, possibly something like the below.

*** DA.py       2003-12-04 21:57:38.000000000 +0000
--- /home/rjmunro/DA.py 2004-05-07 16:38:41.000000000 +0100
***************
*** 329,335 ****
                  '<dtml-var manage_tabs>\n<hr>\n%s\n\n'
                  '<hr><strong>SQL used:</strong><br>\n<pre>\n%s\n</pre>\n<hr>\n'
                  '</body></html>'
!                 % (r,src))

              report=apply(report,(self,REQUEST),{self.id:result})

--- 329,335 ----
                  '<dtml-var manage_tabs>\n<hr>\n%s\n\n'
                  '<hr><strong>SQL used:</strong><br>\n<pre>\n%s\n</pre>\n<hr>\n'
                  '</body></html>'
!                 % (r,html_quote(src)))

              report=apply(report,(self,REQUEST),{self.id:result})


==============================================================