From 9d36c5db63043dde1160fae994845f2913f42ac7 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Mon, 3 Oct 2016 15:45:12 +0200 Subject: [PATCH] replace CR and LF in RFID_SID --- lib/LDAP/Koha.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 { -- 2.20.1