把BMMC_input打印出来看看
智能提示框的搜索方式是动态数据查询?
脚本可以改成这样试试:
(function(){
var opts = $TOOLS.createOptions();
opts.add("","");
var BMMC_input = getParameter("_keyword"); //模糊查找时用
if (BMMC_input == "" || BMMC_input.length<= 0){
BMMC_input = "";
} //模糊查找时用
var aa = "%";
var sql = "select item_主表字段 AS item_主表字段, item_编号 AS item_编号, '"+getDomainid()+"' as domainid from `obpmsp1`.`tlk_主表`";
if(BMMC_input != ""){
var sql = "select item_主表字段 AS item_主表字段, item_编号 AS item_编号, '"+getDomainid()+"' as domainid from `obpmsp1`.`tlk_主表` where item_编号 LIKE '"+aa+BMMC_input+aa+"' limit 0,2";
}
var BMMCs = queryBySQL(sql);
var rtn = "";
if(BMMCs != null || BMMCs != ''){
for (var iter = BMMCs.iterator(); iter.hasNext();) {
var BMMC = iter.next();
rtn = BMMC.getItemValueAsString("编号");
opts.add(rtn,rtn);
}
}
return opts;
})() |