Bindestriche und ID aus den PopupMenus entfernt und in der FOrm.pm die Speicherung...

[kivitendo-erp.git] / SL / LICENSES.pm

diff --git a/SL/LICENSES.pm b/SL/LICENSES.pm
index 25b4d66..7d5f4ba 100644 (file)
--- 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"} . '%') . "))";
   }