<?xml version="1.0" encoding="windows-1252"?>
<node id="1003915" title="Re^2: Need help escaping literal string" created="2012-11-14 20:47:00" updated="2012-11-14 20:47:00">
<type id="11">
note</type>
<author id="535767">
mrras25</author>
<data>
<field name="doctext">
&lt;p&gt;Thank you for the reply &lt;/p&gt;

How exactly would I do it?

Lets say I have a value of 

&lt;code&gt;
while(@values = $sth-&gt;fetchrow_array) {
   print "$values[8]\n";
}
&lt;/code&gt;

the return value of that is : /vol/enycmmcfl01b_ssd2_home_1b_a/CBirbigl$'s

as you can see if I try and take that value and insert in to an insert statement to execute that through perl 

&lt;code&gt;
my $insert = "insert into dbtable (vol) values ('$values[8]')";

&lt;/code&gt;

the insert statement will now fail because it will look like

&lt;code&gt;
insert into dbtable (vol) valuse ('/vol/enycmmcfl01b_ssd2_home_1b_a/CBirbigl$'s')

&lt;/code&gt;

And well that wont work</field>
<field name="root_node">
1003908</field>
<field name="parent_node">
1003914</field>
</data>
</node>
