src/utils/qa/qaEnsGenes.csh 1.23

1.23 2009/08/11 22:52:15 ann
adding sort to a sql query so it's easier to find your db

Index: src/utils/qa/qaEnsGenes.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/qaEnsGenes.csh,v
retrieving revision 1.22
retrieving revision 1.23
diff -b -B -U 4 -r1.22 -r1.23
--- src/utils/qa/qaEnsGenes.csh	11 Apr 2009 00:37:04 -0000	1.22
+++ src/utils/qa/qaEnsGenes.csh	11 Aug 2009 22:52:15 -0000	1.23
@@ -237,9 +237,9 @@
 # make sure the date column has been updated
 echo "\n\n----------------------"
 echo "the dateReference column in the hgFixed.trackVersion table"
 echo "should say 'current' for your database (or all):"
-hgsql -Ne "SELECT db, dateReference FROM trackVersion WHERE version = $ver AND name = 'ensGene'" hgFixed
+hgsql -Ne "SELECT db, dateReference FROM trackVersion WHERE version = $ver AND name = 'ensGene' ORDER BY db" hgFixed
 
 # check that the corresponding upstream MAF files have been updated
 echo "\n\n----------------------"
 echo "In conjunction with an Ensembl Gene update, some upstream MAF files need"