src/hg/utils/automation/doEnsGeneUpdate.pl 1.24

1.24 2010/04/02 16:34:50 hiram
need quotes around a string in a SQL insert statement
Index: src/hg/utils/automation/doEnsGeneUpdate.pl
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/utils/automation/doEnsGeneUpdate.pl,v
retrieving revision 1.23
retrieving revision 1.24
diff -b -B -U 4 -r1.23 -r1.24
--- src/hg/utils/automation/doEnsGeneUpdate.pl	11 Feb 2010 23:48:34 -0000	1.23
+++ src/hg/utils/automation/doEnsGeneUpdate.pl	2 Apr 2010 16:34:50 -0000	1.24
@@ -208,9 +208,9 @@
     (db, name, who, version, updateTime, comment, source, dateReference) \\
     VALUES("$db", "ensGene", "$ENV{'USER'}", "$ensVersion", now(), \\
 	"identical to previous version $previousEnsVersion", \\
 	"identical to previous version $previousEnsVersion", \\
-	$ensVersionDateReference );' hgFixed
+	"$ensVersionDateReference" );' hgFixed
 _EOF_
 	  );
   } else {
       my $skipInv = "";
@@ -307,9 +307,9 @@
     (db, name, who, version, updateTime, comment, source, dateReference) \\
     VALUES("$db", "vegaGene", "$ENV{'USER'}", "$ensVersion", now(), \\
 	"with peptides $ensPepFile", \\
 	"$ensGtfUrl", \\
-	$ensVersionDateReference );' hgFixed
+	"$ensVersionDateReference" );' hgFixed
 _EOF_
       );
       } else {
       $bossScript->add(<<_EOF_
@@ -317,9 +317,9 @@
     (db, name, who, version, updateTime, comment, source, dateReference) \\
     VALUES("$db", "ensGene", "$ENV{'USER'}", "$ensVersion", now(), \\
 	"with peptides $ensPepFile", \\
 	"$ensGtfUrl", \\
-	$ensVersionDateReference );' hgFixed
+	"$ensVersionDateReference" );' hgFixed
 _EOF_
       );
       }
   }