$bad_relationships_count = $bad_relationships_count->[0]->[0];
- my @existing_relationships = $dbh->selectall_array(q{
- SELECT DISTINCT(relationship)
- FROM (
- SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL
- UNION ALL
- SELECT relationship FROM borrowers WHERE relationship IS NOT NULL) a
+ my @existing_relationships = $dbh->selectall_arrayref(q{
+ SELECT DISTINCT(relationship)
+ FROM (
+ SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL
+ UNION ALL
+ SELECT relationship FROM borrowers WHERE relationship IS NOT NULL) a
});
my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') );