Re: Why does my insert work with DBI but fails with DBIx::Simple?

[Tux]

in reply to Why does my insert work with DBI but fails with DBIx::Simple?

While your example might look harmless, are all the records like that? As in, do ALL the lines validate on splitting on ;?

The example line has no quotation (or UTF-8 or embedded newlines), but once it does, reading your source like this is bound to lead to errors - somewhere.

Use Text::CSV_XS or Text::CSV to parse CSV data. Better yet, if you are doing DBI anyway, why not use DBD::CSV to start with?

[karlgoethebier]

Hi Tux,

"...are all the records like that?"

Yes, and i have no influence on it.

Update:

"...do ALL the lines validate on splitting on ;?"

Yes, i had luck ;-)

"...why not use DBD::CSV to start with?"

Good question. I didn't know it. It looks good, so i'll give it a try.

Thank you and best regards, Karl