I think you're getting closer
$SqlStatement=$db->prepare("SELECT TransDate, TransPmtAmt FROM Cust_ac
+t_da WHERE CustomerNumber = ? AND TransType = 'P'") or die "prepare f
+a
+iled: " . $db->errstr()."\n";

[download]
good. the die is a plus. 
    $SqlStatement->execute($CustomerNumber);

[download]
good. maybe a die here. 
    while ( @stuff = $SqlStatement->fetchrow() ) {

[download]
good. this fixes the seemingly infinite loop that appeared in your first code. 
     # do things with @stuff
        $FormatTransDate = substr($TransDate, 0, 10);
             $FormatTransPmtAmt = sprintf("\$%.2f", $TransPmtAmt);

             print $FormatTransDate;
             print "    ";
             print $FormatTransPmtAmt;
    }

[download]
This is a problem, though. You go to all the trouble of preparing, executing and retrieving data, but where do you use it?
See, the row you're currently working on is stored in @stuff, but you never do anything with it. Do you expect $TransDate, $FormatTransDate and $FormatTrnasPmtAmt to hold information from the database? They're not going to. At least, not from the snippet you posted. If they're defined somewhere else in the code, tell us, and say what they're used for.
Either assign them values from @stuff or use @stuff directly.
I'm willing to help you, but this is a little much... If you have more questions, please, let me know you looked in DBI's POD, or in perl's reference, or perlvar or somewhere. I don't know what you're doing, or why you're changing things, because the alterations have fixed one thing, but then broken another, or just don't make sense. We can try to make this work, but you gotta reach half-way, OK?

In reply to (boo) loop analysis by boo_radley
in thread Loop Question by Anonymous Monk

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.