in reply to Re: Re: DBI w/ AnyData...works except on a couple of files...
in thread DBI w/ AnyData...works except on a couple of files...

I'm currently seeing problems with embedded newlines in CSV files.
Eg. data like the following file
C:\TEMP>cat events.csv
UKEY,CITY,DATE,TIME,TITLE,LOCATION,TYPE
unkey1,perth,27-mar-03,3:15,"guru
god",office,1
unkey2,Melb,12-mar-03,3:15,"at last, at home",home,1
on code like
my $sth = $dbh->prepare("SELECT location, title FROM things"); $sth->execute(); while (my $row = $sth->fetch) {print "@$row\n"; }

Version information