RE: DBD:CSV

[Gaul, Ken]

OK now I am getting ....

DBD::CSV::st execute failed: Missing first row at .........CSV.pm line 171,
<GEN0> line 1.

My CSV contains column headings in the first row, is there something I have
to do to handle this? The docs say that that is default behaviour.

Thanks

Ken.

-----Original Message-----
From: Gaul, Ken [mailto:[EMAIL PROTECTED]]
Sent: 07 May 2002 12:52
To: '[EMAIL PROTECTED]'
Subject: DBD:CSV


I have just tried to use DBD::CSV and seem to be missing something
fundamental

I have written a simple select * from table query which seems to return no
data.
The associated file seems to being read as the NUM_OF_FIELDS in the trace is
getting set to 16. I have attached the trace (level 1) if somebody could
explain what is going on please?

my $dbh = DBI->connect("dbi:CSV:f_dir=.") or die "Connect connect to CSV\n";
$dbh->{'csv_sep_char'} =',';
$dbh->{'RaiseError'} = 1;
$dbh->{'csv_tables'}->{'ISS'} = { 'file' => 'ISS'};
my $sth = $dbh->prepare("select * from ISS");
$sth->execute;
while (my @row = $sth->fetchrow_array){
        print "Looping\n";
        print "@row\n";
}