How to use

safeSqlQueryStringValue

method

in

ca.carleton.gcrc.jdbc.JdbcUtils

  JdbcUtils.safeSqlQueryStringValue("%" + matchText + "%") + ") ";
if (1 == fields.size()) {
    JdbcUtils.safeSqlQueryStringValue(matchText) + ") IN lower(" +
    JdbcUtils.safeSqlQueryIdentifier(fieldString) + "))";
} else {
  if (count < (fields.size() - 1)) {
    orderByClause += "least(coalesce(nullif(position(lower(" +
      JdbcUtils.safeSqlQueryStringValue(matchText) + ") IN lower(" +
      JdbcUtils.safeSqlQueryIdentifier(fieldString) + ")), 0), 9999)";
    orderByClosing += ")";
  } else {
    orderByClause += "coalesce(nullif(position(lower(" +
      JdbcUtils.safeSqlQueryStringValue(matchText) + ") IN lower(" +
      JdbcUtils.safeSqlQueryIdentifier(fieldString) + ")), 0), 9999)";

private String GenerateWhereClause(List<Where> whereParms) throws Exception {
  boolean firstSelect = true;
  String retVal = "";
  Iterator<Where> itWhere = whereParms.iterator();
  while( itWhere.hasNext() ) {
    Where where = itWhere.next();
    if( firstSelect ) {
      firstSelect = false;
      retVal += " WHERE ";
    } else {
      retVal += " AND ";
    }
    retVal += (JdbcUtils.safeSqlQueryIdentifier(where.getLeft()) + " " + where.getOp().getSqlQuery() + " ");
    if( null != where.getStringValue() ) {
      retVal += (JdbcUtils.safeSqlQueryStringValue(where.getStringValue()));
    } else {
      retVal += ""+where.getIntValue();
    }
  }
  return(retVal);
}