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

"foosink1 <[email protected]>" <[email protected]> Sat, 11 Jan 2003 16:40:53 -0000
Newsgroups gmane.network.ubh
Message-ID <[email protected]>
--- In [email protected], "foosink1 <foosink@h...>" <foosink@h...> 
wrote:
> 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;
>     }

Actually, on second look, why are newsgroups ordered by name in 
DB.pm? Seems that ordering by newsgroup_id would allow setting 
priority by id.

Thanks...


------------------------ 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/