X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/434f88fb99625738aa890518309d51a95d611c19..d5993f4f4034603d7d5c08740767c1a40d1e4afb:/SL/IC.pm 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 = ();