[Bio] / FigKernelPackages / FIG.pm Repository:
ViewVC logotype

Diff of /FigKernelPackages/FIG.pm

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

revision 1.674, Wed Mar 12 21:05:29 2008 UTC revision 1.675, Wed Mar 12 21:18:14 2008 UTC
# Line 8814  Line 8814 
8814    
8815      if ($with_type_info)      if ($with_type_info)
8816      {      {
8817          my $res = $dbf->SQL(qq(SELECT i2.protein_id, t.name          my $res = $dbf->SQL(qq(SELECT i2.protein_id, t2.name
8818                                 FROM id_correspondence i1 JOIN id_correspondence i2 ON i1.file_num = i2.file_num AND i1.set_id = i2.set_id                                 FROM id_correspondence i1 JOIN id_correspondence i2 ON i1.file_num = i2.file_num AND i1.set_id = i2.set_id
8819                                  JOIN id_correspondence_type t ON t.id = i2.type                                  JOIN id_correspondence_type t2 ON t2.id = i2.type
8820                                 WHERE i1.protein_id = ? AND i1.searchable = 1                                  JOIN id_correspondence_type t1 ON t1.id = i1.type
8821                                   WHERE i1.protein_id = ? AND t1.searchable = 1
8822                                 ), undef, $id);                                 ), undef, $id);
8823          return @$res;          return @$res;
8824      }      }
# Line 8825  Line 8826 
8826      {      {
8827          my $res = $dbh->selectcol_arrayref(qq(SELECT i2.protein_id          my $res = $dbh->selectcol_arrayref(qq(SELECT i2.protein_id
8828                                                FROM id_correspondence i1 JOIN id_correspondence i2 ON i1.file_num = i2.file_num AND i1.set_id = i2.set_id                                                FROM id_correspondence i1 JOIN id_correspondence i2 ON i1.file_num = i2.file_num AND i1.set_id = i2.set_id
8829                                                WHERE i1.protein_id = ? AND i1.searchable = 1), undef, $id);                                                JOIN id_correspondence_type t1 ON t1.id = i1.type
8830                                                  WHERE i1.protein_id = ? AND t1.searchable = 1), undef, $id);
8831          return @$res;          return @$res;
8832      }      }
8833  }  }

Legend:
Removed from v.1.674  
changed lines
  Added in v.1.675

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3