my $crid = $crm->db->selectrow_array("SELECT idPerson FROM Person WHERE email = ? OR altEmail = ?", undef, $data{'email'}, $data{'email'}); print "ERROR: " . $crm->db->errstr if $crm->db->err; print "#$data{'email'}# - $crid"; #### SELECT idPerson FROM Person WHERE email = 'me@examle.com' OR altEmail = 'me@example.com' 90 102 #### my $query = $crm->db->prepare("SELECT idPerson FROM Person WHERE email = ? OR altEmail = ?"); $query->execute($data{'email'}, $data{'email'}); my $crid = $query->fetchrow_array; print "ERROR: " . $crm->db->errstr if $crm->db->err;