in reply to Re^6: mysql update table how to
in thread mysql update table how to
Why take the risk, it's easy enough to avoid
my $sql= 'UPDATE EmployerJobs SET Disabled = ? WHERE USERID = ?'; my $dbh = DB::connect (); my $count = $dbh->do($sql,undef,$DISABLED,$userid); $dbh->disconnect (); printf "%d records updated\n",$count;
also be aware that by not using the ->update_record() method in package DB::TableInfo you could be missing important audit logging or database consistency/integrity checks.
poj
In Section
Seekers of Perl Wisdom