my $sql = "SELECT ports_per_slot FROM tblResNetSwitches WHERE hostname='$host'";
my $sth = $null_dbh->prepare($sql);
if (!defined($sth)) {
my $str = $dbh->errstr;
die("No sth " . $str);
}
if(!($sth->execute())) {
my $str = $dbh->errstr;
die("Couldn't Execute " . $str);
}
my @results = $sth->fetchrow_array;
my $port_p_slot = $results[0];
my $i = 0;
while ($port > $port_p_slot) {
$port = $port - $port_p_slot;
$i++;
}
my $val = '';
SWITCH: {
$val = 'A', last SWITCH if $i == '0';
$val = 'B', last SWITCH if $i == '1';
$val = 'C', last SWITCH if $i == '2';
$val = 'D', last SWITCH if $i == '3';
$val = 'E', last SWITCH if $i == '4';
$val = 'F', last SWITCH if $i == '5';
$val = 'G', last SWITCH if $i == '6';
$val = 'H', last SWITCH if $i == '7';
$val = 'I', last SWITCH if $i == '8';
$val = 'J', last SWITCH if $i == '9';
} # End Switch on letters
my $human_port = $val . $port;