[Date Prev][Date Next][Thread Prev][Thread Next] [Search] [Date Index] [Thread Index]

Re: [MacPerl] DBI errors



At 12:34 PM -0700 4/12/00, Mike Schienle wrote:
>Hi all -
>
>I'm having a hell of a time getting DBI to work on a CSV file and 
>would really appreciate some help. ...

Following up to my own message here.

I'm sure this isn't the final solution, but I discovered that 
changing the EOL characters to UNIX format in the input file fixes 
the problem. Changing the "csv_eol=\r" portion has the effect of 
allowing SELECTion of all records or only the first record from the 
file, as long as the file is in UNIX EOL format.

I stumbled across this fix by making sure the example in the 
DBD-CSV-0.1022 README would work correctly. That was based on a UNIX 
/etc/passwd file. Leaving the file in UNIX EOL worked fine, switching 
it to Mac EOL brought about the previous behavior.
-- 

Mike Schienle                                 Interactive Visuals, Inc.
mgs@ivsoftware.com                  Remote Sensing and Image Processing
http://www.ivsoftware.com/         Analysis and Application Development

# ===== Want to unsubscribe from this list?
# ===== Send mail with body "unsubscribe" to macperl-request@macperl.org