Re: DBD::CSV - SQL Syntax - "AND" clause is not working properly

[Anonymous Monk]

Note: Quoting "Strings" using double quotes are recognized as quoted identifiers (column or table names).

#!/usr/bin/perl --
use strict; use warnings;
use Data::Dump;
use DBI;
use DBD::CSV;
my $dbh = DBI->connect(
    "dbi:CSV:",
    undef, undef,
    { RaiseError => 1 },
);
my $sth = $dbh->prepare_cached('
select *
from test.csv
where OS=?
and RELEASE=?
LIMIT 8
');
$sth->execute( 'Fedora', 'Stentz' );
dd $sth->fetchall_arrayref;
__END__
[["Fedora", "Stentz", 4]]

[slayedbylucifer]

All, Thank you very much for your time and suggestion. the ultimate issue was a screwed up SQL::Statement module installation. I got it re-installed and my script is working fine. Please find more details here: http://stackoverflow.com/questions/12164087/perl-dbdcsv-sql-syntax-and-clause-is-not-working-properly

[marto]

Again, vastly different from the code you posted here, which didn't even compile. The code you posted on SO looks like a combination of the replies you got here.

[slayedbylucifer]

Thats correct marto. This thread helped me to write the code in a better and correct manner which constituted my SO thread. But even after doing that, I did not get the intended result. Later it turned out that SQ::Statement was not properly installed. I want to thank you guys for your time and the guidance.