How can I correctly quote query parameters using DBI?

Posted by imerez on Stack Overflow See other posts from Stack Overflow or by imerez
Published on 2010-04-15T10:25:32Z Indexed on 2010/04/15 10:43 UTC
Read the original article Hit count: 270

Filed under:

perl

|

escaped-characters

|

sql

I am dumping the a number of things including the following into a db INSERT statement

\"$rec->{reqHdrs}\"

However when for example my value for reqHdrs contains quotes it causes the statement to end and thus cause invalid sql.

e.g.

bla;bla="http://www.yahoo.com/xhtml",bla bla

How do I escape the double quotes inside this statement ?

© Stack Overflow or respective owner

Related posts about perl

Munin on Centos 6 - missing perl MODULE_COMPAT_5.8.8

as seen on Server Fault - Search for 'Server Fault'
I'm trying to install Munin on a new VPS through yum install munin but I keep getting an error about a missing perl module: Requires: perl(:MODULE_COMPAT_5.8.8). This is the perl version currently installed: v5.10.1. I've searched all around and still haven't found a solution for this. Here's the… >>> More
Pain removing a perl rootkit

as seen on Server Fault - Search for 'Server Fault'
So, we host a geoservice webserver thing at the office. Someone apparently broke into this box (probably via ftp or ssh), and put some kind of irc-managed rootkit thing. Now I'm trying to clean the whole thing up, I found the process pid who tries to connect via irc, but i can't figure out who's… >>> More
How To Avoid a Perl script calling an Another Perl Script

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, i am calling a perl script client.pl from a main script to capture the output of client.pl in @output. is there anyway to avoid the use of these two files so i can use the output of client.pl in main.pl itself here is my code.... main.pl ======= my @output = readpipe("client.pl"); client… >>> More
Perl :how to sort dates in perl

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can I sort the dates in perl. my @dates = ( "02/11/2009" , "12/20/2001" , "11/21/2010" ) ; I have above dates in my array . How can I sort those dates... ? My date format is dd/mm/YYYY. >>> More
please suggest a perl book exclusively for perl programs

as seen on Stack Overflow - Search for 'Stack Overflow'
I want tha name of a perl book for only PERL PROGRAMS. The reason behind is I want to improve my programming skill in perl >>> More

Related posts about escaped-characters

How to display escaped characters in tmux status bar

as seen on Super User - Search for 'Super User'
i am running tmux from a tty on an embedded linux device. (NOT a terminal emulator) because the screen is rather small, i want to add some "icons" to the tmux status bar. to achieve this, i have simply created a font with the appropriate glyphs for things like battery, or wifi. i can load the font… >>> More
can a valid xml body have escaped characters for the '<' and '>' around the element names

as seen on Stack Overflow - Search for 'Stack Overflow'
My web service is receiving xml from a third party that looks like this: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <SOAP-ENV:Body> <Foo>bar</Foo> </SOAP-ENV:Body> </SOAP-ENV:Envelope> My jaxws web service… >>> More
Using Regex Replace when looking for un-escaped characters

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a requirement that is basically this. If I have a string of text such as "There once was an 'ugly' duckling but it could never have been \'Scarlett\' Johansen" then I'd like to match the quotes that haven't already been escaped. These would be the ones around 'ugly' not the ones around… >>> More
Building a Hashtag in Javascript without matching Anchor Names, BBCode or Escaped Characters

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to convert any instances of a hashtag in a String into a linked URL: #hashtag - should have "#hashtag" linked. This is a #hashtag - should have "#hashtag" linked. This is a [url=http://www.mysite.com/#name]named anchor[/url] - should not be linked. This isn't a pretty way to… >>> More
How to convert a string with escaped characters into a "normal" string

as seen on Stack Overflow - Search for 'Stack Overflow'
Let's say that I have like this: "\\n", I need to convert it to a string like if the interpreter would do it: \n. A simple replace like this wouldn't work: function aaa(s){ return s.replace(/\\n/gm,'\n').replace(/\\\\/gm,'\\'); } I need this behaviour: "Line 1\nLine 2" = Line 1<Line… >>> More