I'm using sqlite for my perl cgi website but I've got a problem with the
following select statement...
SELECT userID FROM members WHERE userName='John' AND
userOccupation='Carpenter'
Yet if I input this statement from the sqlite3 command prompt it works! The
problem seems to be with the 'and', the following statement works fine in
both cgi script and from the sqlite3 prompt...
SELECT userID FROM members WHERE userName='John'
I hope somebody can help with this, I'm new to both perl and sqlite but very
keen on using sqlite for future projects.
here is my perl script...
#!/usr/bin/perl
use DBI;
my $output;
my $sql = "SELECT userID FROM members WHERE userName='John' AND
userOccupation='Carpenter'";
my $dbh = DBI->connect("dbi:SQLite:test.db", "", "");
my $sth = $dbh->prepare($sql);
$sth->execute();
while ( @row = $sth->fetchrow_array ) {
$output .= "@row\n";
}
$dbh -> disconnect;
print "Content-type:text/html\n\n";
print "<html><body><h1>Hello World</h1> $output </body></html>";
--
View this message in context:
http://www.nabble.com/newbie-problem-with-select-statement-using-%27AND%27-tp19561141p19561141.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
