in reply to returning first row of SQL query
my $query="SELECT severity, source, displayname FROM alert WHERE displayname LIKE '%$displayname%' ORDER BY severity DESC LIMIT 1"; my ($severity, $source, $displayname) = $dbh->selectrow_array($query);
In Section
Seekers of Perl Wisdom