X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/54e4131e091831e00a861fe2c4f53e344b87ddca..777bf75cfcfc81a87479a508ea900de4a64c483e:/SL/LICENSES.pm 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"} . '%') . "))"; }