Re: displaying to_char formatting in Perl

[Andrew Gaffney]

There isn't really a syntax error in your SQL query, but Perl is creating one. 
Because of the interpolation issue I described in my previous post, Perl is 
generating the line:

TO_CHAR(ie_dollar_amt, ',999.99'),
MCMULLIN, NANCY wrote:
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

--
Andrew Gaffney
Network Administrator
Skyline Aeronautics, LLC.
636-357-1548
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>