return db_fetch($result);
}
+function delete_printer($id)
+{
+ $sql="DELETE FROM ".TB_PREF."printers WHERE id=".db_escape($id);
+ db_query($sql,"could not delete printer definition");
+}
//============================================================================
// printer profiles functions
//
."(profile, report, printer) VALUES ("
.db_escape($name).","
.db_escape($rep).","
- .db_escape($printer).")";
+ .db_escape($printer ? $printer: null, true).")";
} else {
$sql = "DELETE FROM ".TB_PREF."print_profiles WHERE ("
."report=" . db_escape($rep)
function get_report_printer($profile, $report)
{
$sql = "SELECT printer FROM ".TB_PREF."print_profiles WHERE "
- ."profile=".db_escape($profile)." AND report=".db_escape($report);
+ ."profile=".db_escape($profile)." AND report=";
$result = db_query($sql.db_escape($report), 'report printer lookup failed');
return db_query($sql,"could not get printing profile");
}
-?>
\ No newline at end of file