Re: Request help with DBD::CSV code sample that is not working as expected on UNIX (Solaris).

2002-07-24 Thread Jeff Zucker
Andrew Crum wrote: Oh, yeah, I forgot to mention that these two lines are redundant: > $dbh->{csv_tables}->{table}->{skip_rows} = 0; > $dbh->{csv_tables}->{table}->{col_names} = [qw( col1 col2 col3 col4)]; csv_skip_rows is automatically set to 0 if you specify the col_names parameter so you d

Re: Request help with DBD::CSV code sample that is not working as expected on UNIX (Solaris).

2002-07-24 Thread Jeff Zucker
Andrew Crum wrote: > I would think the actual vs expected indicates an issue with 'csv_eol' > param but I've burned much time trying various settings. Yes, the problem is csv_eol and that you aren't setting it to what you think you are setting it to: > DBI->connect('dbi:CSV:csv_eol=\n;csv_

Request help with DBD::CSV code sample that is not working as expected on UNIX (Solaris).

2002-07-24 Thread Andrew Crum
Can anyone help identify why following code block will fetch only one row when csv_tables->{skip_rows} is set to 0? A solution for this will go a long way toward solving a more complex scenario I'm attempting to help someone with. I would think the actual vs expected indicates an issue with 'csv