SQL Suggestion: May be nit pickin, but this helps makes behavior consistant

Perhaps add an ORDER BY to the newsgroup pulls so that the array 
fills in order, such as

sub process_servers
{
.
.
.
    if ($opt{'G'}) {
.
.
.
    else {
        # Get list of groups from database.
        my $sth_newsgroups = 
            $dbh->prepare(
                          "SELECT newsgroup_id,name,output_dir ".
                          "FROM newsgroups ".
                          "WHERE active='T' ".
                          "ORDER BY newsgroup_id");
.
.
.
        }
        $sth_newsgroups->finish;
    }


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Turn flat surfaces into speakers with the Soundbug.
http://us.click.yahoo.com/QWAVSC/onCFAA/xGHJAA/IHFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/