本帖最后由 echochen 于 2013-11-28 18:12 编辑
函数代码如下:
function getExpertsPercentByPass(parentid){
var sql="select cast(cast((select count(*)from tlk_f_zjopinion where item_IsPassReview ='通过' or item_IsPassReview='调整后通过' and parent='"+parentid+"')*1.0*100/count(*) as decimal(10,2)) as varchar(50)) +'%' as item_percent,'1' as domainid,'2' as id from tlk_f_zjopinion where (cast(item_nowuser as nvarchar) is not null or cast(item_nowuser as nvarchar) !='')";
println("===sql==="+sql);
var data =queryBySQL(sql);
println("====data=="+data );
var count=0;
if(data !=null){
for(var iter =data.iterator();iter.hasNext();){
var doc=iter.next();
count =doc.getItemValueAsString("percent");
}
}
return count;
}
打印sql语句有数据,但data为空,什么原因呢?(注sqlserver数据库)
|