SPUG: DBD::CSV Problems

Tom Heady spug at punch.net
Tue Apr 12 21:52:34 PDT 2005


>   my $dbh = DBI->connect( "DBI:CSV:f_dir=/home/jc/data/yahoo.csv" ) ;

This should be:
my $dbh = DBI->connect( "DBI:CSV:f_dir=/home/jc/data/" ) ;

Then later..

my $sth = $dbh->prepare( "select * from yahoo" );


The directory is the "database".
The file is the "table".
The ".csv" is unnecessary.

This and more is available in the docs here:
http://search.cpan.org/dist/DBD-CSV/


More information about the spug-list mailing list