src/hg/lib/makeItemsItem.c 1.4
1.4 2010/04/10 06:11:50 kent
Adding id field to makeItemsItem.
Index: src/hg/lib/makeItemsItem.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/makeItemsItem.c,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 4 -r1.3 -r1.4
--- src/hg/lib/makeItemsItem.c 10 Apr 2010 01:13:58 -0000 1.3
+++ src/hg/lib/makeItemsItem.c 10 Apr 2010 06:11:50 -0000 1.4
@@ -59,9 +59,9 @@
* For example "autosql's features include" --> "autosql\'s features include"
* If worried about this use makeItemsItemSaveToDbEscaped() */
{
struct dyString *update = newDyString(updateSize);
-dyStringPrintf(update, "insert into %s values ( %u,'%s',%u,%u,'%s',%u,'%s',%u,%u,%u,%s)",
+dyStringPrintf(update, "insert into %s values ( %u,'%s',%u,%u,'%s',%u,'%s',%u,%u,%u,%s,0)",
tableName, el->bin, el->chrom, el->chromStart, el->chromEnd, el->name, el->score, el->strand, el->thickStart, el->thickEnd, el->itemRgb, el->description);
sqlUpdate(conn, update->string);
freeDyString(&update);
}
@@ -81,9 +81,9 @@
name = sqlEscapeString(el->name);
strand = sqlEscapeString(el->strand);
description = sqlEscapeString(el->description);
-dyStringPrintf(update, "insert into %s values ( %u,'%s',%u,%u,'%s',%u,'%s',%u,%u,%u,'%s')",
+dyStringPrintf(update, "insert into %s values ( %u,'%s',%u,%u,'%s',%u,'%s',%u,%u,%u,'%s',0)",
tableName, el->bin, chrom, el->chromStart, el->chromEnd, name, el->score, strand, el->thickStart, el->thickEnd, el->itemRgb, description);
sqlUpdate(conn, update->string);
freeDyString(&update);
freez(&chrom);