$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();
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"} . '%') . "))";
}