in reply to Database Connectivity
DBI will take care of all the quoting for you. Or, if you'd rather not use placeholders (for whatever reason), at least don't try to do the quoting yourself; use:my $query = "SELECT * from table1 WHERE pacos=?"; my $results = $dbh->prepare($query); $results->execute("tacos") or die "Exec err: ", $dbh->errstr;
my $query = "SELECT * from table1 WHERE pacos=" . $dbh->quote("tacos") +;
|
|---|