Re: Perl script Mysql update help

[Randy Clamons]

Where do you get the error, on the prepare or the execute?

Usually, you would do it like this:

$sql = 'UPDATE snmpcol SET sysUpTime = ? WHERE IP = ?';
$sth = $dbh->prepare($sql) or die "Cannot prepare: " . $dbh->errstr();
$sth->execute($snmpresult,"192.168.1.60") or die "Cannot execute: " . $sth->errstr();
$sth->finish();