Select Code to Download

Select or download this

DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver
+] Syntax error in INSERT INTO statement. (SQL-42000)(DBD: st_prepare/
+SQLPrepare err=-1) at SearchPubMed2.pl line 325.
Can't call method "execute" on an undefined value at SearchPubMed2.pl 
+line 326.

Select or download this

if ($AtLeastOneValueToInsert == 1) {
    $FinalInsertSQL = $StartInsertSQL . $InsertColumnSQL . $InsertValu
+esSQL;
      if ($debug1 == 1) {print "now updating SearchResults table\n"};
...
    $sth->execute()           # Execute the insert
     or die "Couldn't execute statement: " . $sth->errstr;
    $sth->finish;