Re: DBD::CSV: perl script to read CSV file does not work

2008-06-02 Thread Jeff Zucker
Hi Prakash, You wrote: $dbh->do(UPDATE ...) is not working as per the recommended syntax. The query returns a 0 (undef?) for the line: $dbh->do("UPDATE info SET Owner = 'me' WHERE SerialNumber = '1234") or die "update: " . $dbh->errstr(); I suggest you turn on RaiseError in your connect stat

Re: DBD::CSV: perl script to read CSV file does not work

2008-06-02 Thread Prakash Prabhakar
$dbh->do(UPDATE ...) is not working as per the recommended syntax. The query returns a 0 (undef?) for the line: $dbh->do("UPDATE info SET Owner = 'me' WHERE SerialNumber = '1234") or die "update: " . $dbh->errstr(); Is there anything that I am missing? -

Re: DBD::CSV: perl script to read CSV file does not work

2008-06-02 Thread Prakash Prabhakar
Jeff, All, Thank you very much for that information. My code's working now. Regards, Prakash On 6/1/08, Jeff Zucker <[EMAIL PROTECTED]> wrote: > > ReneeB wrote: > >> >> Why do you use the Windows line endings as the default? Why not the value >> of $/? >> >> Because 1) the module was already se

Re: DBD::CSV: perl script to read CSV file does not work

2008-06-01 Thread Jeff Zucker
ReneeB wrote: Why do you use the Windows line endings as the default? Why not the value of $/? Because 1) the module was already several years old and widely used when I inherited it and I didn't want to break backward compatability 2) Because, I think using $/ would be a disaster since you

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread ReneeB
Hi Jeff, Jeff Zucker wrote: Prakash Prabhakar wrote: I am using the following code in my .cgi progam (compiling with perl-5.8.6, UNIX OS). It doesnt work. Could you please let me know what could be wrong? I do not get any warnings/error messages/expected output. The .cgi and the .csv are in

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Jeff Zucker
le was created on windows or mac or with something other than '\012' as the line ending, using "\n" on linux will not work. -- Jeff --- On Sun, 6/1/08, Jeff Zucker <[EMAIL PROTECTED]> wrote: From: Jeff Zucker <[EMAIL PROTECTED]> Subject: Re: DBD::CSV: perl

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Andon Tschauschev
' => "\n" > }; yes, it works fine on linux... --- On Sun, 6/1/08, Jeff Zucker <[EMAIL PROTECTED]> wrote: > From: Jeff Zucker <[EMAIL PROTECTED]> > Subject: Re: DBD::CSV: perl script to read CSV file does not work > To: "Prakash Prabhakar"

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Jeff Zucker
Prakash Prabhakar wrote: I am using the following code in my .cgi progam (compiling with perl-5.8.6, UNIX OS). It doesnt work. Could you please let me know what could be wrong? I do not get any warnings/error messages/expected output. The .cgi and the .csv are in the same directory. My guess i

Re: DBD::CSV: perl script to read CSV file does not work

2008-05-31 Thread Andon Tschauschev
ket: https://rt.cpan.org/Public/Bug/Display.html?id=33764 Regards Andon --- On Sat, 5/31/08, Prakash Prabhakar <[EMAIL PROTECTED]> wrote: > From: Prakash Prabhakar <[EMAIL PROTECTED]> > Subject: DBD::CSV: perl script to read CSV file does not work > To: dbi-users@perl.org &g

DBD::CSV: perl script to read CSV file does not work

2008-05-30 Thread Prakash Prabhakar
I am using the following code in my .cgi progam (compiling with perl-5.8.6, UNIX OS). It doesnt work. Could you please let me know what could be wrong? I do not get any warnings/error messages/expected output. The .cgi and the .csv are in the same directory. Thanks, Prakash use warnings; use DBI;