Thank you for the quick response
I am afraid though, that you misread my question.
The issue I am having is not between "0E0" vs "0" being returned (that was a side note to indicate that I have already accounted for that), my issue is that the number of rows affected by the query is not being consistently returned. With $dbh->do I get a consistent return value but I cannot prepare with ?'s. If I prepare the statement and assign it to a statement handle my $sth = $dbh->prepare($query) || die $dbh->errstr; I cannot count on getting the number of rows affected. Is this consistent with DBI? or does this behavior seem specific to my system setup? Is there a property of the $dbh I should be checking?

You also mentioned utilizing placeholders ? within a $dbh->do() call, where could I find information regarding that, or would you be so kind as to offer an example?

Like I hopefully mentioned earlier this is not a critical issue for me but I figured I should post it as a question in case there was someone else who has seen this behavior and had already found the explaination/solution. Thank you again
-injunjoel

In reply to Re: Answer: Return values from $dbh->do vs. $sth->execute(); by injunjoel
in thread Return values from $dbh->do vs. $sth->execute(); by injunjoel

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.