All pastes #168383 Raw Edit

Something

public text v1 · immutable
·published 2006-09-12 22:47 UTC
rendered paste body
        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;