RE: Misunderstanding column_info/fetchrow_array

2004-02-24 Thread McMahon, Chris
PROTECTED]' > Subject: Re: Misunderstanding column_info/fetchrow_array > > > Insert this line below the fetchrow_array: > > foreach (@info) { $_ = 'NULL' unless defined $_ } > or > defined($_) or $_ = 'NULL' foreach @info; > > t

Re: Misunderstanding column_info/fetchrow_array

2004-02-24 Thread Tim Bunce
Insert this line below the fetchrow_array: foreach (@info) { $_ = 'NULL' unless defined $_ } or defined($_) or $_ = 'NULL' foreach @info; take your pick. Then go read the DBI docs about how NULLs are represented as undef values. Tim. On Tue, Feb 24, 2004 at 09:21:31AM -0700, Mc

Re: Misunderstanding column_info/fetchrow_array

2004-02-24 Thread Michael A Chase
McMahon, Chris wrote: I'm a DBI newbie. I've written a little script that reports the description of each column in a table. The script works fine, but when it runs it reports warnings that I don't understand. Here's the script: *** use warnings; use DBI; m

Misunderstanding column_info/fetchrow_array

2004-02-24 Thread McMahon, Chris
Hello... I'm a DBI newbie. I've written a little script that reports the description of each column in a table. The script works fine, but when it runs it reports warnings that I don't understand. Here's the script: *** use warnings; use DBI; my $s