Dear Perl Monks,

Thank you for your help on my previous quandary! I found the error, but have moved on to others. At this point in my program I'm having trouble inserting retrieved values from the PubMed database back into my Access database. Does the following error message generally refer to a problem with SQL scripts or with the Perl script? 

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.

[download]

Here is a segment of the code surrounding that line 326, if it helps:

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

[download]

Here is the "insert into" variable definition from earlier on in that subroutine:

my $StartInsertSQL = 'insert into SearchResult(';

Thanks for any advice!!

In reply to Another DB question by molly

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.