From b90f03e45d33ac76d0d5ec34132831bfbf55e15d Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 8 Jul 2008 08:12:08 +0000 Subject: [PATCH] Debugcode --- SL/DO.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/DO.pm b/SL/DO.pm index 620f1e06a..ef6a10b69 100644 --- a/SL/DO.pm +++ b/SL/DO.pm @@ -393,7 +393,7 @@ sub mark_orders_if_delivered { my $all_units = AM->retrieve_all_units(); - $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit + my $query = qq|SELECT oi.parts_id, oi.qty, oi.unit, p.unit AS partunit FROM orderitems oi LEFT JOIN parts p ON (oi.parts_id = p.id) WHERE (oi.trans_id = ?)|; -- 2.20.1