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