Sorry. The original error I reported was due to a syntax error. I fixed that. What's happening is when I do not include the line: TO_CHAR(ie_dollar_amt, '$999,999.99'), it displays 366 records correctly.
With that line included - it comes up with "Query returned 0 records" - no data. (Thank you for reminding me about CGI:Carp.. I will include it in all programs.) -----Original Message----- From: Jan Eden [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 1:38 PM To: MCMULLIN, NANCY; Perl Lists Subject: RE: displaying to_char formatting in Perl Hi Nancy, MCMULLIN, NANCY wrote on 27.05.2004: >The error is "Internal Server Error". >As soon as I comment out the (2)lines below: >-- TO_CHAR(ie_dollar_amt, '$999,999.99'), >it works just fine. As suggested before: use CGI::Carp qw(fatalsToBrowser); You'll get a more informative error message then. - Jan -- A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
