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_
);
}
}