<?xml version="1.0" encoding="windows-1252"?>
<node id="10883" title="ODBC question" created="2000-05-10 03:36:48" updated="2005-08-14 02:49:06">
<type id="115">
perlquestion</type>
<author id="8564">
Eugene</author>
<data>
<field name="doctext">
I am using Win32::ODBC and trying to insert into my db like&lt;br&gt;
&lt;code&gt;
$val1 = 1;
$val2 = "'";

$db-&gt;Sql("INSERT INTO Comment ( Field1, Field2 )VALUES ('$val1', '$val2') ");
&lt;/code&gt;

That doesn't work because SQL doesn't like ' ' '.  Is there a way around it?</field>
</data>
</node>
