<?xml version="1.0" encoding="windows-1252"?>
<node id="440842" title="Re^6: DBH Insert of Binary Data" created="2005-03-18 20:36:06" updated="2005-03-18 21:10:52">
<type id="11">
note</type>
<author id="157432">
Joost</author>
<data>
<field name="doctext">
&lt;code&gt;
#!perl -w
use strict;
use DBI;

my $dbh = DBI-&gt;connect('DBI:mysql:database=test','xxx','yyy',) || die;
print $dbh-&gt;quote(q{Boston;DELETE FROM myTable});
__END__
'Boston;DELETE FROM myTable'
&lt;/code&gt;
&lt;p&gt;
I don't see your point. If any DBD driver let's this through, (and DBD::mysql doesn't), it's a major bug. Yes, it might be inefficient, but it should never lead to a security risk if used correctly.
&lt;p&gt;
&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-157432"&gt;
&lt;em&gt;[id://149675|"What should it profit a man, if he should win a flame war, yet lose his cool?"]&lt;/em&gt;

&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
440788</field>
<field name="parent_node">
440823</field>
</data>
</node>
