Help for this page

Select Code to Download


  1. or download this
    # 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";
    
  2. or download this
    # 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;