replace CR and LF in RFID_SID

diff --git a/lib/LDAP/Koha.pm b/lib/LDAP/Koha.pm
index 7415278..0769ecb 100644 (file)
--- a/lib/LDAP/Koha.pm
+++ b/lib/LDAP/Koha.pm
@@ -46,7 +46,7 @@ my $ldap_sql_mapping = {
        'objectGUID'    => 'b.borrowernumber',
        'displayName'   => 'surname',
        'sn'            => 'surname',
        'objectGUID'    => 'b.borrowernumber',
        'displayName'   => 'surname',
        'sn'            => 'surname',

-       'pager'         => qq{replace(a.attribute, '\r','')},   # was: rfid_sid
+       'pager'         => qq{replace(replace(a.attribute, char(13),''),char(10),'')},  # was: rfid_sid

 };
 
 sub __sql_column {
 };
 
 sub __sql_column {