From d5993f4f4034603d7d5c08740767c1a40d1e4afb Mon Sep 17 00:00:00 2001
From: =?utf8?q?Jan=20B=C3=BCren?= <information@richardson-bueren.de>
Date: Tue, 12 May 2009 09:59:24 +0000
Subject: [PATCH] =?utf8?q?Hotfix=20f=C3=BCr=20Fehler=20bei=20Lieferantenau?=
 =?utf8?q?ftrag=20per=20E-Mail=20versenden,=20aufgrund=20von=20Revision=20?=
 =?utf8?q?4093=20@mb=20Bei=20der=20Migration=20w=C3=A4re=20ein=20Umwandeln?=
 =?utf8?q?=20in=20der=20DB=20in=20Tabelle=20makemodell=20make=3D=3Dvendor?=
 =?utf8?q?=5Fid=20sinnvoll.=20Morgen=20mehr?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 SL/IC.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/SL/IC.pm b/SL/IC.pm
index c84365fb6..b021422d4 100644
--- a/SL/IC.pm
+++ b/SL/IC.pm
@@ -1820,7 +1820,7 @@ sub prepare_parts_for_printing {
   my $placeholders = join ', ', ('?') x scalar(@part_ids);
   my $query        = qq|SELECT mm.parts_id, mm.model, v.name AS make
                         FROM makemodel mm
-                        LEFT JOIN vendor v ON (mm.make = v.id)
+                        LEFT JOIN vendor v ON (mm.make = cast (v.id as text))
                         WHERE mm.parts_id IN ($placeholders)|;
 
   my %makemodel    = ();
-- 
2.20.1