Hey Perl Monks,
I am really stuck! I have a Perl program that executes the following code snippet:
$InsertIntoMetar = <<SQL;
REPLACE INTO Metar
$sth = $dbh->prepare($InsertIntoMetar)
or die "Can't prepare $InsertIntoMetar: $dbh->errstr\n";
$rv = $sth->execute
+ ##Insert into production Metar table.
or die "can't execute the query: $sth->errstr";
The script dies with the following on the command line:
can't execute the query: DBI:: st=HASH(0x1a07924)-> errstr at Load_Met
+ar_New1.pl line 600. Line 600 is the line that contains the $rv = $
+sth->execute shown above.
The interesting thing is that I can cut and paste the SQL contained in the prepare portion of the $LoadIntoMetar into a SQLYog window and it executes just fine!!