in reply to DBD::CSV - SQL Syntax - "AND" clause is not working properly
Replace:
my $query = "SELECT VERSION from test.csv WHERE OS="Fedora" AND RELEASE="Stentz"with:
my $query = "SELECT VERSION from test.csv WHERE OS='Fedora' AND RELEASE='Stentz'";You can't be posting the code you're actually running. You were missing a semicolon at the end of the line, also note how I quote the values. You'd have the same problem with Oracle, contrary to your claim.
Update: Basic working example:
#!/usr/bin/perl use strict; use warnings; use DBI; my $dbh = DBI->connect ("dbi:CSV:") or die "Cannot connect: $DBI::errs +tr"; $dbh->{csv_tables}->{testtable} = { 'file' => 'test.csv', }; my $query = "SELECT VERSION from test.csv WHERE OS='Fedora' AND RELEAS +E='Stentz'"; my $sth = $dbh->prepare($query); $sth->execute; $sth->dump_results(); $dbh->disconnect();
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: DBD::CSV - SQL Syntax - "AND" clause is not working properly
by slayedbylucifer (Scribe) on Aug 28, 2012 at 11:26 UTC | |
by marto (Cardinal) on Aug 28, 2012 at 11:31 UTC | |
by slayedbylucifer (Scribe) on Aug 28, 2012 at 11:41 UTC | |
by marto (Cardinal) on Aug 28, 2012 at 11:47 UTC |
In Section
Seekers of Perl Wisdom