Add strictures to the start of your code: use strict; use warnings;. That may not help your immediate problem (unless one of the variables you are concatenating together are undefined), but it will save you mega time in the future.

Turn on your debugging (look for a commented out $debug1 = 1; and uncomment it or add my $debug1 = 1; just after the strictures) so you can see the contents of $FinalInsertSQL. If you can't see the error in the SQL, update your node to include that vital piece of information.

BTW, there are two errors there - one reported by DBD and one reported by Perl so the answer to your actual question is: "Both!"

DWIM is Perl's answer to Gödel

In reply to Re: Another DB question by GrandFather
in thread Another DB question by molly

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.