From 0b787068795c80a71f084f65070619fbd36e80b4 Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Mon, 24 Sep 2007 16:26:25 +0200 Subject: [PATCH] FIX for 1391, search on 1 digit cardnumber Signed-off-by: Chris Cormack --- C4/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Members.pm b/C4/Members.pm index 1dc87e118c..0d3b6b03a7 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -160,8 +160,8 @@ sub SearchMember { "SELECT * FROM borrowers LEFT JOIN categories ON borrowers.categorycode=categories.categorycode ". ($category_type?" AND category_type = ".$dbh->quote($category_type):""). - " WHERE surname LIKE ? ORDER BY $orderby"; - @bind = ("$searchstring%"); + " WHERE surname LIKE ? OR cardnumber like ? ORDER BY $orderby"; + @bind = ("$searchstring%","$searchstring"); } else # advanced search looking in surname, firstname and othernames { -- 2.20.1