From bb57d074ea0934925c358f98349c95a7a0d58983 Mon Sep 17 00:00:00 2001 From: Joy Nelson Date: Thu, 22 Sep 2011 22:36:48 -0400 Subject: [PATCH] Bug 6773: circ/ysearch.pl is unlimited Added a LIMIT 10 to the SQL statement Edited the circulation.pref stating that autocomplete returns the first 10 results at a time Signed-off-by: Ian Walls --- circ/ysearch.pl | 3 ++- .../en/modules/admin/preferences/circulation.pref | 1 + 2 files changed, 3 insertions(+), 1 deletions(-) diff --git a/circ/ysearch.pl b/circ/ysearch.pl index 549a547..ce890f5 100755 --- a/circ/ysearch.pl +++ b/circ/ysearch.pl @@ -47,7 +47,8 @@ my $sql = qq(SELECT surname, firstname, cardnumber, address, city, zipcode, coun WHERE surname LIKE ? OR firstname LIKE ? OR cardnumber LIKE ? - ORDER BY surname, firstname); + ORDER BY surname, firstname + LIMIT 10); my $sth = $dbh->prepare( $sql ); $sth->execute("$query%", "$query%", "$query%"); diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref index dc821a8..eae7541 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref @@ -7,6 +7,7 @@ Circulation: yes: Try no: "Don't try" - to guess the patron being entered while typing a patron search on the circulation screen. + - Only returns the first 10 results are returned at a time. - - pref: itemBarcodeInputFilter choices: -- 1.7.4.1