http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7977 --- Comment #59 from Chris Nighswonger <cnighswonger@foundations.edu> --- (In reply to comment #57)
(In reply to comment #55)
Created attachment 9504 [details] Followup patch addressing items pointed out by Jonathan Druart
Hi Chris, Thanks for your followup.
However, I think the following syntax is not usable:
$iTotalRecords = $dbh->selectrow_array("SELECT count(*) FROM quotes WHERE id LIKE %?% OR source LIKE %?% OR text LIKE %?% OR timestamp LIKE %?%;",undef,($filter, $filter, $filter, $filter));
You can write this like:
$iTotalRecords = $dbh->selectrow_array("SELECT count(*) FROM quotes WHERE id LIKE ? OR source LIKE ? OR text LIKE ? OR timestamp LIKE ?;",undef,("%$filter%")x4);
This is actually unused due to the removal of server-side processing, so I've attached another followup removing it from quotes_ajax.pl Thanks! -- You are receiving this mail because: You are watching all bug changes.