Select Code to Download

DBD::Pg::st execute failed: execute called with an unbound placeholder
+ at ./refresh_dates.pl line nn.
DBD::Pg::st execute failed: execute called with an unbound placeholder
+ at ./refresh_dates.pl line nn.

# Or:
Can't locate object method "execute" via package "DBI::db" at ./refres
+h_dates.pl line nn.

Global symbol "$prepare" requires explicit package name at ./refresh_d
+ates.pl line nn.
Execution of ./refresh_dates.pl aborted due to compilation errors.

my $sth2 = $dbh->$prepare("update $schema.$table set $date_col = $date
+_new where $where_col = 1;") or die;
$sth2->execute();

#!/bin/perl
use strict;
...

# Close the database
$dbh->disconnect() or die RED, "ERROR: The database could not be disco
+nnected.\n       $DBI::errstr\n       Stopped$!";