Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
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 cooling their heels in the Monastery: (4)
As of 2014-08-30 23:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls