Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: A bug in DBD::CSV?

by cosimo (Hermit)
on Apr 13, 2006 at 13:00 UTC ( [id://543060]=note: print w/replies, xml ) Need Help??


in reply to A bug in DBD::CSV?

Hi Evan,
Change:

while( defined ( my @row = $sth->fetchrow_array ) ) {
to:
while( my @row = $sth->fetchrow_array ) {
and an endless loop problem is fixed.
I think the other problem is your peculiar choice of quote_char.
I found that specifying the general quote char on DBI connection options makes the error go away. As you probably know, this is a general setting, not per table/csv handle.
my $dbh = DBI->connect('DBI:CSV:f_dir=.;csv_quote_char=~;') or die .. +.
I didn't have time to investigate on this one, though it would be interesting to do.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://543060]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (4)
As of 2024-03-29 10:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found