[ZCM] [ZC] 1322/ 2 Assign "ZSQL testing "

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

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

==============================================================
= Assign - Entry #2 by ajung on May 14, 2004 1:03 am

 Status: Pending => Accepted

 Supporters added: ajung


________________________________________
= 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})


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