my $query = "UPDATE items SET ";
my @bind;
for my $key ( keys %$item ) {
next if $key eq 'itemnumber';
$query.="$key=?,";
push @bind, $item->{$key};
}
-