[Koha-bugs] [Bug 7977] Add a "Quote-of-the-day" feature to the OPAC homepage

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri May 11 13:43:53 CEST 2012


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

--- Comment #59 from Chris Nighswonger <cnighswonger at 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.


More information about the Koha-bugs mailing list