From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Mon, 3 Oct 2016 13:45:12 +0000 (+0200)
Subject: replace CR and LF in RFID_SID
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=9d36c5db63043dde1160fae994845f2913f42ac7;ds=sidebyside

replace CR and LF in RFID_SID
---

diff --git a/lib/LDAP/Koha.pm b/lib/LDAP/Koha.pm
index 7415278..0769ecb 100644
--- 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',
-	'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 {