X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FForm.pm;h=7803fc394b94aca0928c7051f47b4a8cc95719d2;hb=09335d0f463d5fff5b1b620ffc61f3ad48ab793a;hp=537372a7cd2b759b5d3f1224e37a3b483c25ba96;hpb=4311578257aa2e5808580def7e80a38d493646b0;p=kivitendo-erp.git diff --git a/SL/Form.pm b/SL/Form.pm index 537372a7c..7803fc394 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2488,12 +2488,13 @@ sub get_history { qq|SELECT h.employee_id, h.itime::timestamp(0) AS itime, h.addition, h.what_done, emp.name, h.snumbers, h.trans_id AS id | . qq|FROM history_erp h | . qq|LEFT JOIN employee emp ON (emp.id = h.employee_id) | . - qq|WHERE trans_id = ? |. $order - . $restriction; - + qq|WHERE trans_id = | . $trans_id + . $restriction . qq| | + . $order; + my $sth = $dbh->prepare($query) || $self->dberror($query); - $sth->execute($trans_id) || $self->dberror("$query ($trans_id)"); + $sth->execute() || $self->dberror("$query"); while(my $hash_ref = $sth->fetchrow_hashref()) { $hash_ref->{addition} = $main::locale->text($hash_ref->{addition});