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