------------------------- $dbh = DBI->connect("DBI:CSV:f_dir=/amd/homes/banni/PI/DB") or die "Cannot connect: " . $DBI::errstr; $table='etl'; $dbh->{'RaiseError'} = 1; $@ = ''; eval { $query = "SELECT playercode,playername FROM $table"; $sth = $dbh->prepare($query); $sth->execute(); $sth->execute(); while ($sth->fetchrow_arrayref()) { print("Found result row: @$_\n"); } $fields = $sth->{NUM_OF_FIELDS}; print "Fields = $fields\n"; $sth->finish(); }; ---------------------- #### playercode,playername 1,Apple/iPod/iPhone 2,Leap Frog/Leapster 3,Microsoft Zune 4,Mylo