[Koha-bugs] [Bug 7618] HTML special characters break result table and incorrectly show SQL in Run This Report

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7618

--- Comment #1 from David Cook <dcook at prosentient.com.au> 2012-03-02 00:13:13 UTC ---
Created attachment 7976
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=7976
Bug 7618 HTML Escaped SQL

It's just a simple change to the intranet template for the Guided Reports in
Koha 3.2.

If you look at the template, the SQL is also displayed in a hidden field which
is already HTML special character escaped. I just copied that format, and voila
it worked. 

The fix for Koha 3.6+ could be achieved similarly.

Rationale:

I had noticed that any SQL report with angle brackets (< >) wouldn't display
properly when running a report, since the browser would interpret it as HTML.
Besides being an incorrect representation of the SQL used in the report, it
also had the tendency of breaking the result table, which often meant that all
the results were a single string flowing out of the SQL.

It's quite an uncommon problem overall, but it's a re-occurring issue with
reports using the older method of retrieving values from marcxml fields.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.