Re^2: database selecting then validating

[Anonymous Monk]

You could simplify that into (assuming a unique constraint on (empid, dept)):

my $sql = 'select 1 from users where empid=? and dept=?';
if ($dbh->selectrow_array($sql, undef, $empid, $dept)) {
  # valid
} else {
  # not valid
}

...I'm always a bit wary of using Count(*) for exists-or-not-exists queries