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