Folks,
I wish to do two things using DBI:
1. Update a table:
$update ="update table_A set field_1='Y' where field_2='Y' and serialnum=?
2. Produce a confirmation report on updates I just made
$confirm ="select name, number from table_A for those rows I just updated"
Questions:
How do I implement this?
Here's what I have
--------------------------
$update ="update table_A set field_1='Y' where field_2='Y' and serialnum=?"
$confirm ="select name, number from table_A where serialnum=?"
$dbh->connect ......
while (<>) {
chomp;
$sth->prepare $update
$sth->execute ....
$sth->prepare $confirm ## is this kosher??
$sth->execute ## or do I need to $sth->finish , commit, in
here after update??
}
---------------------------------------
Thanks,
Frank
