Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Custom DBD error message

by sweetblood (Prior)
on Nov 12, 2012 at 19:10 UTC ( #1003489=note: print w/replies, xml ) Need Help??

in reply to Custom DBD error message

The problem is not the error, and not necessarily your code, although it seems odd that you say you are loading the contents of the csv file into a hash and are getting dupes. This is a data issue, if you expect to be passing data to mysql table and you have defined keys, they must be unique. Now you can de-dup your data by loading the data into a hash with keys that are the same as you are using in your table which means you will lose records that may or may not matter, very hard to tell since you have been so vague as to what you are doing. If you need all the records then you must determine what makes a unique record and build you keys accordingly.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1003489]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (10)
As of 2018-06-22 14:10 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (124 votes). Check out past polls.