Assuming that line 13 is the line where you assign $tmpStr and that line 17 is the line where you execute the $queryObj (it would have been nice if you'd told us the line numbers), then the unitialized value is probably from missing CGI parameters (e.g. they were left blank when the form was submitted or they are not spelled correctly). The unkown column error is pretty self explanatory ... did you perhaps mean to have an underscore instead of period between FIRST and NAME?

Once you get those issues resolved, you should read the DBI docs on placeholders because putting your CGI parameters directly in the SQL like you do is not a good idea.

In reply to Re: Error adding a record into a MySQL table: 'Unknown column ...' by jZed
in thread Error adding a record into a MySQL table: 'Unknown column ...' by stanleyscup

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.