Re: displaying to_char formatting in Perl

Wiggins d Anconia wrote: Please bottom post I only top-post when other people in the thread do because it keeps things a little less confusing. It annoys the crap out of me, though. -- Andrew Gaffney Network Administrator Skyline Aeronautics, LLC. 636-357-1548 -- To unsubscribe, e-mail: [EMAI

Re: displaying to_char formatting in Perl

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 > > > >

Re: displaying to_char formatting in Perl

MCMULLIN, NANCY wrote: Thank you kindly. That fixed it. No problem. I do that all the time ;) -- Andrew Gaffney Network Administrator Skyline Aeronautics, LLC. 636-357-1548 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: displaying to_char formatting in Perl

bout 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

RE: displaying to_char formatting in Perl

Thank you kindly. That fixed it. -Original Message- From: Andrew Gaffney [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 1:42 PM To: MCMULLIN, NANCY Cc: Wiggins d Anconia; [EMAIL PROTECTED] Subject: Re: displaying to_char formatting in Perl MCMULLIN, NANCY wrote: > The error

Re: displaying to_char formatting in Perl

MCMULLIN, NANCY wrote: 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. Here's the code: == #!c:/activeperl/bin/perl use strict; use DBI; use DBD::Oracle; use CGI qw(:standard *table *Tr

RE: displaying to_char formatting in Perl

" - 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,

RE: displaying to_char formatting in Perl

; > exit; > } > print header( -type =>"text/html" ), > start_html( -title => "...", -bgcolor => "#FEF3DE", -font face => "tahoma", -font size => "1",), > start_table( > { -border

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 messag

RE: displaying to_char formatting in Perl

foreach (@$ar) { print start_Tr(), td( \%bgca, $_ ), end_Tr; $NUM_OF_ROWS++; } print end_table; my ($name, $value); print end_html; warn "error: $DBI::errstr\

Re: displaying to_char formatting in Perl

> When attempting to display a formatted string in Perl using Oracle - > > SELECT >TO_CHAR(dollar_amt, '$999,999.99') >FROM >table; > > It breaks the code. It does work as a straight SQL query outside of Perl. Any ideas? > "It breaks the code" is a rather vague statement. How d