<?xml version="1.0" encoding="windows-1252"?>
<node id="1015266" title="Re: Error &quot;'exists ^0^' has chars not alphanumeric or underscore in perl&quot;" created="2013-01-25 00:14:16" updated="2013-01-25 00:14:16">
<type id="11">
note</type>
<author id="159887">
NetWallah</author>
<data>
<field name="doctext">
The error seems to be emanating from [cpan://SQL::Parser] - which looks like it is getting confused by the complex SQL syntax.&lt;p&gt;
Try re-designing your SQL statement using UNION or INTERSECTION - maybe that will get past the Parser.&lt;p&gt;
Sorry - I'm not a SQL guru, and dont know the syntax well enough to actually provide the alternative.&lt;p&gt;
BTW - your attempt to clear the SQL of funny characters has a bug - it deletes the "%" after "Data%" - leading to potentially undesirable results.&lt;p&gt;The SQL string shown is clean to start with - it does not need the regex you have attempted to use.

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-159887"&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;small&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;
Most people believe that if it ain't broke, don't fix it.&lt;br&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;
Engineers believe that if it ain't broke, it doesn't have enough features yet.
&lt;/small&gt;&lt;/p&gt;
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
1015264</field>
<field name="parent_node">
1015264</field>
</data>
</node>
