Help for this page

Select Code to Download


  1. or download this
    # For example:
    my $sql = "insert into lookup (SYS_ACC,REPORT_NAME,JOB_NAME) values (?
    +,?,?)";
    my $sth = $dbh->prepare($sql) or die $dbh->errstr;
    $sth->execute($sys_acc, $report, $job) or die $sth->errstr #update: fo
    +rgot error check
    # Easier to read and how it was intended.
    
  2. or download this
    my $countofrowsaffected = $dbh->do($sql, undef, $sys_acc, $report, $jo
    +b) or die $dbh->errstr;