perlquestion
slayedbylucifer
<p>
Hello Monks.
</p>
<p>
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.
</p>
<p>
e.g., consider following table called test.csv:
</p>
<code>
OS,RELEASE,VERSION
Ubuntu,Warty,4
Ubuntu,Hoary,5
Ubuntu,Breezy,5
Fedora,Yarrow,1
Fedora,Tettnang,2
Fedora,Stentz,4
</code>
<p>
So, I want to list the version for Fedora Stentz which is "4".
</p>
<p>
I have written below query:
</p>
<code>
my $query = "SELECT VERSION from test.csv WHERE OS="Fedora" AND RELEASE="Stentz";
my $sth = $dbh->prepare ($query);
$sth->execute;
</code>
<p>
However, I get below error:
</p>
<code>
DBD::CSV::st execute failed: No such column '"Fedora" AND RELEASE="Stentz"' at /usr/local/lib/perl/5.10.1/DBI/DBD/SqlEngine.pm line 796
</code>
<p>
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.
</p>
<p>
however, I am not able to put "AND" clause to work in above query.
</p>
<p>
I hve referred the documnetion @ [mod://SQL::Statement::Syntax] (which is used by DBD::CSV), however it doensn't talk much about the "AND" clause usage.
</p>
<p>
Could you help in correcting the query please.
</p>
<p>
-Thnaks.
</p>