From a7898c0c39d2fb499efde2ab709f05c6ca318550 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 30 Jun 2010 13:58:32 +0200 Subject: [PATCH] [followup](MT3160) fix address request If any part of concat is null, all the address field is null. Now we use IFNULL() from mysql. Signed-off-by: Henri-Damien LAURENT --- C4/Overdues.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/C4/Overdues.pm b/C4/Overdues.pm index d9bd420a39..2a226ac846 100644 --- a/C4/Overdues.pm +++ b/C4/Overdues.pm @@ -199,7 +199,11 @@ sub GetOverduesByBorrowers{ surname, firstname, title, - CONCAT(borrowers.streetnumber, ' ', borrowers.address, '\n', borrowers.address2) as address, + CONCAT( + IFNULL(borrowers.streetnumber,''), ' ', + IFNULL(borrowers.streettype,'') , ' ' , + IFNULL(borrowers.address,''), '\n', IFNULL(borrowers.address2,'') + ) as address, city, zipcode, email, -- 2.39.5