[Koha-bugs] [Bug 9915] Allow opac/svc/report to be passed sql parameters

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

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

--- Comment #8 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Hm I tested it too and it does look like the params are not replaced in the
SQL:

[Sun Apr 07 13:21:18 2013] [error] [client 127.0.0.1] [Sun Apr  7 13:21:18
2013] report: DBD::mysql::st execute failed: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near '<<holding|branches>> and homebranch =
<<home|branches>> LIMIT 0, 10' at line 1 at
/home/katrin/kohaclone/C4/Reports/Guided.pm line 507.
[Sun Apr 07 13:21:18 2013] [error] [client 127.0.0.1] [Sun Apr  7 13:21:18
2013] report: DBD::mysql::st fetchall_arrayref failed: fetch() without
execute() at /home/katrin/kohaclone/svc/report line 60.


My report is:
select * from items where holdingbranch = <<holding|branches>> and homebranch =
<<home|branches>>

Used URL:
http://localhost:8080/cgi-bin/koha/svc/report?id=2&sql_params=MPL&sql_params=MPL

-- 
You are receiving this mail because:
You are watching all bug changes.