Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^4: SQL::Statement confusing literals and identifiers (now with workaround!)

by bcarroll (Monk)
on May 28, 2009 at 14:31 UTC ( #766675=note: print w/ replies, xml ) Need Help??


in reply to Re^3: SQL::Statement confusing literals and identifiers (now with workaround!)
in thread SQL::Statement confusing literals and identifiers

The problem is that the .csv file referenced has fields with quotes in it. Remove the quotes and the errors should go away. Pay attention to the "chunk" that is referenced in the error, that number should be the line number of the problematic text. I spent a lot of time debugging this same error and once I removed the double-quotes (") from the text in the .csv all errors went away.


Comment on Re^4: SQL::Statement confusing literals and identifiers (now with workaround!)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2014-07-10 02:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (198 votes), past polls