Please bottom post.... > 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'), >
Actually I think it should be TO_CHAR(ie_dollar_mt, '99,999.99'), cause Perl is recognizing $9 as one of the normal $<digits> variables used in capturing in regexes. strictures won't catch that since it is a special pre-declared value, but warnings would have complained about an uninitialized value (assuming it isn't set). Good reason to turn warnings, even the uninitialized category, on. http://danconia.org > 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> > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
