From 4bbda034644723750a11c5693953390cc229a0a7 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 11 Jun 2014 15:05:31 +0200 Subject: [PATCH] Bug 9811: Cardnumber could be alphanumeric Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- 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 2edbc50280..992d67fadf 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"; -- 2.39.5