/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func) { if (val instanceof Lit || val instanceof Param) if (func.indexOf("VARCHAR") == -1) func = addCastAsString(func, "{0}", " AS VARCHAR(1000)"); return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func) { if (val instanceof Lit || val instanceof Param) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func) { if (val instanceof Lit || val instanceof Param) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func) { if (val instanceof Lit || val instanceof Param) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func) { if (val instanceof Lit || val instanceof Param) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @param col database column * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func, Column col) { boolean doCast = false; if (val instanceof Lit || val instanceof Param) { doCast = true; } // cast anything not already a VARCHAR to VARCHAR if (col.getType() != Types.VARCHAR) { doCast = true; } if (doCast == true) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @param col database column * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func, Column col) { boolean doCast = false; if (val instanceof Lit || val instanceof Param) { doCast = true; } // cast anything not already a VARCHAR to VARCHAR if (col.getType() != Types.VARCHAR) { doCast = true; } if (doCast == true) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @param col database column * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func, Column col) { boolean doCast = false; if (val instanceof Lit || val instanceof Param) { doCast = true; } // cast anything not already a VARCHAR to VARCHAR if (col.getType() != Types.VARCHAR) { doCast = true; } if (doCast == true) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }
/** * Return the correct CAST function syntax * * @param val operand of cast * @param func original string * @param col database column * @return a String with the correct CAST function syntax */ public String getCastFunction(Val val, String func, Column col) { boolean doCast = false; if (val instanceof Lit || val instanceof Param) { doCast = true; } // cast anything not already a VARCHAR to VARCHAR if (col.getType() != Types.VARCHAR) { doCast = true; } if (doCast == true) { if (func.indexOf("VARCHAR") == -1) { func = addCastAsString(func, "{0}", " AS VARCHAR(" + varcharCastLength + ")"); } } return func; }