$dbh->do("UPDATE INV SET SOLD=\"$updy\" WHERE CODE==$CODE");

##</code><code>##

$sth=$dbh->prepare("UPDATE INV SET SOLD=? WHERE CODE==?");
$sth->execute($updy,$CODE); # Why is that var all UPcase, BTW?