Help for this page
# this works, but don't do it... The "correct" way is bind-vars $value = $dbh->quote("sneaky text with posessives' in it"); $sql = "u +pdate set column = $value";
# Do this every time: my $sth = $dbh->prepare("update table set column=?") or die $dbh->errs +tr; $sth->execute("sneaky text with posessives' in it") or die $dbh->er +rstr;