|Problems? Is your data what you think it is?|
DBD::CSV - SQL Syntax - "AND" clause is not working properlyby slayedbylucifer (Scribe)
|on Aug 28, 2012 at 11:11 UTC||Need Help??|
slayedbylucifer has asked for the
wisdom of the Perl Monks concerning the following question:
I am using DBI and the CSV driver DBD::CSV for manipulating the the CSV files. my SELECT query is not interpreting the way I want it ot.
e.g., consider following table called test.csv:
So, I want to list the version for Fedora Stentz which is "4".
I have written below query:
However, I get below error:
So, This means the use of "AND" clause is causing the problem. I have worked a little bit on Oracle DB and know that the above Query would work fine on Oracle DB.
however, I am not able to put "AND" clause to work in above query.
I hve referred the documnetion @ SQL::Statement::Syntax (which is used by DBD::CSV), however it doensn't talk much about the "AND" clause usage.
Could you help in correcting the query please.