Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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

by Tux (Monsignor)
on Feb 18, 2013 at 13:19 UTC ( #1019338=note: print w/ replies, xml ) Need Help??


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?


Enjoy, Have FUN! H.Merijn


Comment on Re: Why does my insert work with DBI but fails with DBIx::Simple?
Download Code
Replies are listed 'Best First'.
Re^2: Why does my insert work with DBI but fails with DBIx::Simple?
by karlgoethebier (Vicar) on Feb 18, 2013 at 14:10 UTC

    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

    «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (9)
As of 2015-07-08 07:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (96 votes), past polls