Okay...i ran this code and i die after the sql statement. Is this because I am not using the DBI interface??? Is there a way to do this without the DBI interface? I see what you are saying about the @stuff.... The 2 format variables are defined in that loop. $TransDate and $TransPmtAmt is supposed to be variables used to get data from the columns TransDate and TransPmtAmt in the database. So in order to get that information I have to do this:

$TransDate=$stuff[1];
$TransPmtAmt=$stuff[2];
$FormatTransDate = substr($TransDate, 0, 10);
$FormatTransPmtAmt = sprintf("\$%.2f", $TransPmtAmt);

             print $FormatTransDate;
             print "    ";
             print $FormatTransPmtAmt;
[download]