[Bio] / SeedViewer / MetagenomeAnalysis.pm Repository:
ViewVC logotype

Diff of /SeedViewer/MetagenomeAnalysis.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.16, Fri Jun 13 14:53:32 2008 UTC revision 1.17, Fri Jun 13 16:47:56 2008 UTC
# Line 554  Line 554 
554    my $where = $self->get_where_clause();    my $where = $self->get_where_clause();
555    $where = ($where) ? "and $where" : '';    $where = ($where) ? "and $where" : '';
556    
557    my $sth = $self->dbh->prepare("select tax_group_1, tax_group_2, tax_group_3, tax_str, count(*) as num from $table where dbid=$dbid group by tax_group_1, tax_group_2, tax_group_3, tax_str");    my $sth = $self->dbh->prepare("select tax_group_1, tax_group_2, tax_group_3, tax_str, count(*) as num from $table where dbid=$dbid $where group by tax_group_1, tax_group_2, tax_group_3, tax_str");
558    
559    $sth->execute;    $sth->execute;
560    my $result = $sth->fetchall_arrayref();    my $result = $sth->fetchall_arrayref();

Legend:
Removed from v.1.16  
changed lines
  Added in v.1.17

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3