Help for this page

Select Code to Download


  1. or download this
    my $sql6 =  "UPDATE table_name SET good_high = $threshold_good_high, c
    +ritical_low = $threshold_critical_low, warning_low = $threshold_warni
    +ng_low, warning_high = $threshold_warning_high WHERE user = ? AND nam
    +e = '$threshold_name'";
    my $sth6 = $dbh->prepare($sql6);
    $sth6->execute($userName);
    $update_result1 = $sth6->rows;
    print "\$update_result1: $update_result1\n";
    
  2. or download this
    my $sth6 = $dbh->do("UPDATE table_name SET good_high = $threshold_good
    +_high, critical_low = $threshold_critical_low, warning_low = $thresho
    +ld_warning_low, warning_high = $threshold_warning_high WHERE user = ?
    + AND name = '$threshold_name'");
    print "\$sth6: $sth6\n";