From 8c667be6de60615f1cb2dd8fb9a65e785ee8f412 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 21 Feb 2007 07:57:37 +0000 Subject: [PATCH] =?utf8?q?Query=20zum=20Speichern=20der=20Zahlungseing?= =?utf8?q?=C3=A4nge=20bzgl.=20project=5Fid=20gefixt.=20Bugzilla-ID=20559.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IS.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/SL/IS.pm b/SL/IS.pm index 18c615fcf..aa2b087bf 100644 --- a/SL/IS.pm +++ b/SL/IS.pm @@ -927,11 +927,11 @@ sub post_invoice { $form->{"paid_$i"} *= -1; $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, - source, memo, ?) + source, memo, project_id) VALUES ($form->{id}, (SELECT c.id FROM chart c - WHERE c.accno = '$accno', project_id), + WHERE c.accno = '$accno'), $form->{"paid_$i"}, '$form->{"datepaid_$i"}', - '$form->{"source_$i"}', '$form->{"memo_$i"}')|; + '$form->{"source_$i"}', '$form->{"memo_$i"}', ?)|; do_query($form, $dbh, $query, $project_id); # exchangerate difference -- 2.20.1