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

(-)a/C4/Members.pm (-3 lines)
Lines 149-155 sub GetMemberDetails { Link Here
149
            SELECT borrowers.*,
149
            SELECT borrowers.*,
150
                   category_type,
150
                   category_type,
151
                   categories.description,
151
                   categories.description,
152
                   enrolmentperiod
153
            FROM borrowers
152
            FROM borrowers
154
            LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
153
            LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
155
            WHERE borrowernumber = ?
154
            WHERE borrowernumber = ?
Lines 161-167 sub GetMemberDetails { Link Here
161
            SELECT borrowers.*,
160
            SELECT borrowers.*,
162
                   category_type,
161
                   category_type,
163
                   categories.description,
162
                   categories.description,
164
                   enrolmentperiod
165
            FROM borrowers
163
            FROM borrowers
166
            LEFT JOIN categories ON borrowers.categorycode = categories.categorycode
164
            LEFT JOIN categories ON borrowers.categorycode = categories.categorycode
167
            WHERE cardnumber = ?
165
            WHERE cardnumber = ?
168
- 

Return to bug 17578