code: public final String evalSqlUpdate(final String pTable,
      final ColumnsValues pColumnsVals,
        final String pWhere) throws Exception {
      StringBuffer result = new StringBuffer("update "
        + pTable + " set \n");
      boolean isFirstField = true;
      ColumnsValues cv = filterCv(pColumnsVals, false);
      for (String key : cv.getIntegersMap().keySet()) {
        if (isFirstField) {
          isFirstField = false;
        } else {
          result.append(", ");
        }
        result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
      }
      for (String key : cv.getLongsMap().keySet()) {
        if (isFirstField) {
          isFirstField = false;
        } else {
          result.append(", ");
        }
        result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
      }
      for (String key : cv.getFloatsMap().keySet()) {
        if (isFirstField) {
          isFirstField = false;
        } else {
          result.append(", ");
        }
        result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
      }
      for (String key : cv.getDoublesMap().keySet()) {
        if (isFirstField) {
          isFirstField = false;
        } else {
          result.append(", ");
        }
        result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
      }
      for (String key : cv.getStringsMap().keySet()) {
        if (isFirstField) {
          isFirstField = false;
        } else {
          result.append(", ");
        }
        result.append(key.toUpperCase() + "=" + cv.evalSqlValue(key));
      }
      if (pWhere != null) {
      result.append(" where " + pWhere);
      }
      result.append(";\n");
      return result.toString();
    }
docs: <p>Evaluate SQL update statement.
  </p>
  @param pTable table name
  @param pColumnsVals type-safe map column name - column value
  @param pWhere where conditions e.g. "itsId=2 AND itsVersion=2"
  @return row count affected
  @throws Exception - an exception