List,
Below is my sub where I want to INSERT the following values into a
PostgreSQL database that contatins a row that needs some entries updated.
Can any one see a problem with the following code?
sub complete_final{
my $status = 'COMPLETE';
my $sth = $dbh ->prepare( qq{ INSERT INTO
vintek_support
(date_complete,time_complete,status,administrator,solution)
VALUES (?,?,?,?,?) WHERE unique_id =
'$search_string1'
} ) || die $dbh->errstr;
$sth->execute($date_added,$time_added,$status,$admin,$solution);
}
Regards,
df
