Yep sorry my bad. That was a mistake.

The code actually does the right thing (INSERT for new objects, UPDATE for existing). Since the SQL is automatically generated (and since DBI doesn't let you see the actual SQL that goes through to the DB (unless you want an awful lot of debugging information as well), I just typed them in off the top of my head.

The top of my head needs a bit of work :-)

Anyway, the SQL statements generated are syntacticly correct, except when a quoted date comes into the arena :-)

I can't use the suggestion you offer unfortunately, because all SQL is generated on the fly, based on configuration data.

Without looking at each component of each INSERT/UPDATE, I don't know which ones I have to treat 'specially', and which ones I can use placeholders for.

In reply to Re: Re: DBI quoting when I don't want it to by Tardis
in thread DBI quoting when I don't want it to by Tardis

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.