1f73ebb9d827c6da5b2e96985ce062051341f030
galt
  Thu Jun 13 10:09:28 2013 -0700
needed %-s for where clause
diff --git src/hg/lib/ccdsInfo.c src/hg/lib/ccdsInfo.c
index 9df16e1..bffa6f0 100644
--- src/hg/lib/ccdsInfo.c
+++ src/hg/lib/ccdsInfo.c
@@ -242,53 +242,53 @@
     break;
 }
 return extraWhere;
 }
 
 struct ccdsInfo *ccdsInfoSelectByCcds(struct sqlConnection *conn, char *ccdsId,
                                       enum ccdsInfoSrcDb srcDb)
 /* Obtain list of ccdsInfo object for the specified id and srcDb.  If srcDb is
  * ccdsInfoNull, return all srcDbs.  Return NULL if ccdsId it's not valid */
 {
 char query[256];
 struct sqlResult *sr;
 char **row;
 struct ccdsInfo *ccdsInfos = NULL;
 
-sqlSafef(query, sizeof(query), "select * from ccdsInfo where ccds = \"%s\"%s",
+sqlSafef(query, sizeof(query), "select * from ccdsInfo where ccds = '%s'%-s",
       ccdsId, getSrcDbWhere(srcDb));
 sr = sqlGetResult(conn, query);
 
 while ((row = sqlNextRow(sr)) != NULL)
     slSafeAddHead(&ccdsInfos, ccdsInfoLoad(row));
 sqlFreeResult(&sr);
 
 return ccdsInfos;
 }
 
 struct ccdsInfo *ccdsInfoSelectByMrna(struct sqlConnection *conn, char *mrnaAcc)
 /* Obtain of ccdsInfo object for the specified mRNA or NULL if mrna is not
  * associated with a CCDS.  Version number is optional for RefSeq mrnaAcc */
 {
 char query[256];
 struct sqlResult *sr;
 char **row;
 struct ccdsInfo *ccdsInfo = NULL;
 
 if (genbankIsRefSeqAcc(mrnaAcc) && (strchr(mrnaAcc, '.') == NULL))
-    sqlSafef(query, sizeof(query), "select * from ccdsInfo where mrnaAcc like \"%s.%%\"",
+    sqlSafef(query, sizeof(query), "select * from ccdsInfo where mrnaAcc like '%s.%%'",
           mrnaAcc);
 else
-    sqlSafef(query, sizeof(query), "select * from ccdsInfo where mrnaAcc = \"%s\"",
+    sqlSafef(query, sizeof(query), "select * from ccdsInfo where mrnaAcc = '%s'",
           mrnaAcc);
 sr = sqlGetResult(conn, query);
 
 /* should only get one, but this is easier to code */
 while ((row = sqlNextRow(sr)) != NULL)
     slSafeAddHead(&ccdsInfo, ccdsInfoLoad(row));
 sqlFreeResult(&sr);
 
 if ((ccdsInfo != NULL) && (ccdsInfo->next != NULL))
     errAbort("obtained multiple CCDSs for mRNA %s", mrnaAcc);
 
 return ccdsInfo;
 }