/** * Append SQL for the given numeric value to the buffer, casting as needed. */ protected void appendNumericCast(SQLBuffer buf, FilterValue val) { if (val.isConstant()) appendCast(buf, val, Types.NUMERIC); else val.appendTo(buf); }
private void appendXmlExist(SQLBuffer buf, FilterValue lhs) { buf.append(lhs.getColumnAlias( lhs.getFieldMapping().getColumns()[0])). append(".exist('"). append("/*["); lhs.appendTo(buf); }
private void appendXmlExist(SQLBuffer buf, FilterValue lhs) { buf.append(lhs.getColumnAlias(lhs.getFieldMapping().getColumns()[0])) .append(".exist('").append("/*["); lhs.appendTo(buf); }
private void appendXmlExtractValue(SQLBuffer buf, FilterValue val) { buf.append("extractValue("). append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
private void appendXmlExtractValue(SQLBuffer buf, FilterValue val) { buf.append("extractValue("). append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
private void appendXmlExtractValue(SQLBuffer buf, FilterValue val) { buf.append("extractValue("). append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
private void appendXmlExists(SQLBuffer buf, FilterValue val) { buf.append("XMLEXISTS('"); buf.append("$").append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append("/*["); val.appendTo(buf); }
private void appendXmlExtractValue(SQLBuffer buf, FilterValue val) { buf.append("extractValue("). append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
/** * Append XML column value so that it can be used in comparisons. * * @param buf the SQL buffer to write the value * @param val the value to be written */ private void appendXmlValue(SQLBuffer buf, FilterValue val) { buf.append("ExtractValue("). append(val.getColumnAlias(val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
/** * Append XML column value so that it can be used in comparisons. * * @param buf the SQL buffer to write the value * @param val the value to be written */ private void appendXmlValue(SQLBuffer buf, FilterValue val) { buf.append("ExtractValue("). append(val.getColumnAlias(val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
/** * Append XML column value so that it can be used in comparisons. * * @param buf the SQL buffer to write the value * @param val the value to be written */ private void appendXmlValue(SQLBuffer buf, FilterValue val) { buf.append("ExtractValue("). append(val.getColumnAlias(val.getFieldMapping().getColumns()[0])). append(",'/*/"); val.appendTo(buf); buf.append("')"); }
private void appendXmlExists(SQLBuffer buf, FilterValue val) { buf.append("XMLEXISTS('"); buf.append("$").append(val.getColumnAlias( val.getFieldMapping().getColumns()[0])). append("/*["); val.appendTo(buf); }
public void appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) { if (!args[0].isConstant()) throw new UserException(_loc.get("const-only", TAG)); Object val = args[0].getValue(); target.appendTo(buf); if (val == null) buf.append(" IS ").appendValue(null); else buf.append(" LIKE ").appendValue("%" + val + "%"); } }
public void appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) { if (!args[0].isConstant()) throw new UserException(_loc.get("const-only", TAG)); Object val = args[0].getValue(); target.appendTo(buf); if (val == null) buf.append(" IS ").appendValue(null); else buf.append(" LIKE ").appendValue("%" + val + "%"); } }
public void appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) { if (!args[0].isConstant()) throw new UserException(_loc.get("const-only", TAG)); Object val = args[0].getValue(); target.appendTo(buf); if (val == null) buf.append(" IS ").appendValue(null); else buf.append(" LIKE ").appendValue("%" + val + "%"); } }