Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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);


Comment on Re: Inserting into SQL
Download Code
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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2016-02-07 09:34 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (250 votes), past polls