my $query;
- if ( $form->{id} ) {
- $query = qq|DELETE FROM shipto WHERE (trans_id = ?) AND (module = 'CT')|;
- do_query($form, $dbh, $query, $form->{id});
-
- } else {
+ if (!$form->{id}) {
$query = qq|SELECT nextval('id')|;
($form->{id}) = selectrow_query($form, $dbh, $query);
my @values;
my %allowed_sort_columns =
- map({ $_, 1 } qw(id customernumber name address contact phone fax email
+ map({ $_, 1 } qw(id customernumber vendornumber name address contact phone fax email
taxnumber sic_code business invnumber ordnumber quonumber));
$sortorder =
$form->{sort} && $allowed_sort_columns{$form->{sort}} ?