- if (!$params{id}) {
- ($params{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('note_id')|);
- $query = qq|INSERT INTO notes (created_by, trans_id, trans_module, subject, body, id)
- VALUES ((SELECT id FROM employee WHERE login = ?), ?, ?, ?, ?, ?)|;
- push @values, $::myconfig{login}, conv_i($params{trans_id}), $params{trans_module};
+ if (!$params{id}) {
+ ($params{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('note_id')|);
+ $query = qq|INSERT INTO notes (created_by, trans_id, trans_module, subject, body, id)
+ VALUES ((SELECT id FROM employee WHERE login = ?), ?, ?, ?, ?, ?)|;
+ push @values, $::myconfig{login}, conv_i($params{trans_id}), $params{trans_module};