Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re: Inserting into SQL

by snowcrash (Friar)
on Feb 13, 2002 at 11:14 UTC ( #145132=note: print w/replies, xml ) Need Help??

in reply to Inserting into SQL

sounds like a quoting problem to me. when dealing with text or binary data always quote the value like:
my $sql = "INSERT INTO feedback SET fulltext=" . $dbh->quote($feedback);


Replies are listed 'Best First'.
Re: Re: Inserting into SQL
by Masem (Monsignor) on Feb 13, 2002 at 12:51 UTC
    The poster is already using placeholders, which is guarenteed to quote the inputs (either by the DB itself or by DBI if the DB doesn't support it). And placeholders are always more desirable to use than to place the inputs into the SQL statement itself, even if you quote them.

    Dr. Michael K. Neylon - || "You've left the lens cap of your mind on again, Pinky" - The Brain
    "I can see my house from here!"
    It's not what you know, but knowing how to find it if you don't know that's important

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://145132]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (9)
As of 2017-02-22 15:45 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (331 votes). Check out past polls.