View | Details | Raw Unified | Return to bug 9811
Collapse All | Expand All

(-)a/C4/Utils/DataTables/Members.pm (-2 / +1 lines)
Lines 30-36 sub search { Link Here
30
    my $select = "SELECT
30
    my $select = "SELECT
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
32
        borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
32
        borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
33
        CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry,
33
        cardnumber, borrowers.dateexpiry,
34
        borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
34
        borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
35
        categories.description AS category_description, categories.category_type,
35
        categories.description AS category_description, categories.category_type,
36
        branches.branchname";
36
        branches.branchname";
37
- 

Return to bug 9811