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

--- Comment #57 from Jonathan Druart <[email protected]> ---
(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);

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to