469 |
=item save_report($sql,$name,$type,$notes) |
469 |
=item save_report($sql,$name,$type,$notes) |
480 |
"INSERT INTO saved_sql (borrowernumber,date_created,last_modified,savedsql,report_name,type,notes) VALUES (?,now(),now(),?,?,?,?)"; |
481 |
"INSERT INTO saved_sql (borrowernumber,date_created,last_modified,savedsql,report_name,type,notes) VALUES (?,now(),now(),?,?,?,?)"; |
481 |
my $sth = $dbh->prepare($query); |
482 |
$dbh->do( $query, undef, $borrowernumber, $sql, $name, $type, $notes ); |
482 |
$sth->execute( $borrowernumber, $sql, $name, $type, $notes ); |
483 |
my $id = $dbh->selectrow_array("SELECT max(id) FROM saved_sql WHERE borrowernumber=? AND report_name=?", undef, |