From 33b481a6101fd1cd0a59da1626ebd31bd7aff05a Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 11 Jun 2014 15:05:31 +0200 Subject: [PATCH] [PASSED QA] Bug 9811: Cardnumber could be alphanumeric Signed-off-by: Katrin Fischer --- C4/Utils/DataTables/Members.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index 2edbc50..992d67f 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -30,7 +30,7 @@ sub search { my $select = "SELECT borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address, borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country, - CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry, + cardnumber, borrowers.dateexpiry, borrowers.borrowernotes, borrowers.branchcode, borrowers.email, categories.description AS category_description, categories.category_type, branches.branchname"; -- 1.8.3.2