X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FLICENSES.pm;h=7d5f4ba36f5d7dc70409238aa4a3959e5c6c0ae2;hb=e7367fb51e706abc8c54495e1623a5e1d2aca7fa;hp=25b4d66eec2cbf1888955ea81c3c2dcef6d88d2e;hpb=d319704a66e9be64da837ccea10af6774c2b0838;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"} . '%') . "))"; }