}
- my $where = 'WHERE ' . join(' AND ', map { "($_)" } @filters) if (scalar @filters);
+ my $where = @filters ? 'WHERE ' . join(' AND ', map { "($_)" } @filters) : '';
my $sortorder = $params{sort} ? $params{sort} : "projectnumber";
$sortorder =~ s/[^a-z_]//g;
CVar->save_custom_variables('dbh' => $dbh,
'module' => 'Projects',
'trans_id' => $params{id},
- 'variables' => $form);
+ 'variables' => $form,
+ 'always_valid' => 1);
$dbh->commit();