本帖最后由 shary 于 2011-7-28 09:10 编辑
我在做下拉框的时候数据无法提取,下拉框脚本如下:
var opts = createOptions();
opts.add("","");
try{
var process = createProcess("cn.myapps.core.dynaform.dts.datasource.ejb.DataSourceProcess");
var datas = process.queryDataSourceSQL("kd","select ID,AreaName from d_area where FatherID='1'",getApplication());
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();
//取值
var name= map1.get("AreaName");
var value = map1.get("id");
$PRINTER.println("value---> " + value);
opts.add(name,value);
}
}
}catch(e){}
opts;
该select ID,AreaName from d_area where FatherID='1'在数据库中执行完全没有问题。请问怎么解决? |