From ef07ad1fede1a067169794ba9b457e5b82116628 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Wed, 11 Jun 2014 15:05:31 +0200
Subject: [PATCH] Bug 9811: Cardnumber could be alphanumeric
---
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";
--
2.0.0.rc2