# now connect and get a database handle my $dbh = DBI->connect($dsn, $user, $pass) or die "Cant connect to the DB: $DBI::errstr\n"; my $sql="SELECT value FROM res_prior"; my $sth = $dbh->prepare($sql) or die "cant prepare"; $sth->execute($sql) or die "cant execute";
and i get a "cant execute" error from cgi script thats running the query. I can connect to mysql and the query is OK mysql> SELECT value FROM res_prior; +-------+ | value | +-------+ | M | | H | | R | | N | | U | | O | | P | +-------+ 7 rows in set (0.06 sec) mysql> how do i sort out what the problem is ? -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
