my $dbh = $form->get_standard_dbh($myconfig);
my $query = qq|SELECT w.id, w.description, w.invalid,
- (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins,
+ (SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins
FROM warehouse w
ORDER BY w.sortkey|;
FROM warehouse w
WHERE w.id = ?|;
- my $ref = selectfirst_hashref_query($form, $dbh, $query, $id, $id);
+ my $ref = selectfirst_hashref_query($form, $dbh, $query, $id);
map { $form->{$_} = $ref->{$_} } keys %{ $ref };