Yes, most of the fields are arriving in Perl as undef, there are a few that arrive as empty but I'm converting these into undef when found. The use of NULL's is by design. The data I'm collecting my not be complete and as I don't control the raw data there is not much I can do about this. The information (as you may have guessed) is weather data and I'll be calculating average and various other stats from it. I have to use NULL to differentiate between actual data and missing data - I can't use zero for example because it's a real value 0 degrees Celsius is a valid temperature. It's even worse with other parameters as prior to the solution to my Barometric Pressure was being populated with 0mb! Calculating averages with these values would not work as the calculation included the zeros. By inserting NULL the average only calculates based on the actual figures it has and returns the best value possible given the information it has. Not sure if there was a better way to solve this problem but it appears to be working ok for me at the moment.

In reply to Re^2: Writing NULL values to a MySQL record via DBI by ureco
in thread Writing NULL values to a MySQL record via DBI by ureco

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.