X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FLICENSES.pm;h=7d5f4ba36f5d7dc70409238aa4a3959e5c6c0ae2;hb=0ecb31986f567eb0b1e9949978458baba04c0ef9;hp=25b4d66eec2cbf1888955ea81c3c2dcef6d88d2e;hpb=ee072e4f077213bf6f8792ca8f0a1afebbb6282f;p=kivitendo-erp.git diff --git a/SL/LICENSES.pm b/SL/LICENSES.pm index 25b4d66ee..7d5f4ba36 100644 --- a/SL/LICENSES.pm +++ b/SL/LICENSES.pm @@ -69,8 +69,8 @@ sub save_license { $sth->finish(); if ($form->{own_product}) { - $form->update_balance($dbh, "parts", "onhand", qq|id = $form->{parts_id}|, - 1); + $form->update_balance($dbh, "parts", "onhand", qq|id = ?|, + 1, $form->{parts_id}); } $dbh->disconnect(); @@ -127,7 +127,7 @@ sub search { if ($form->{"customer_name"}) { $f .= " AND " if ($f); $f .= - "(customer_id IN (SELECT id FROM customer WHERE name ILIKE " + "(l.customer_id IN (SELECT id FROM customer WHERE name ILIKE " . $dbh->quote('%' . $form->{"customer_name"} . '%') . "))"; }