SQL查询如果获取ID字段

var dql = " select ID as docid , applicationid , item_bianhao , item_lng , item_lat ,domainid from tlk_" + namelist + " where author = '" + userid + "'";
var docs =  queryBySQL(dql);

for (var iter = docs.iterator(); iter.hasNext();) {
     var doc =  iter.next();
     var dst_name = doc.getItemValueAsString("bianhao");
      var lng = doc.getItemValueAsString("lng");
      var lat = doc.getItemValueAsString("lat");
      var docid = doc.getItemValueAsString("docid");
      var applicationid = doc.getItemValueAsString("applicationid");

     rtn =   rtn + "{bh:'" + dst_name + "',lng:'" + lng + "',lat:'" + lat +  "',docid:'"  + docid  + "'},";
}

写了一个sql，  select ID as docid   开头，但是使用 var docid = doc.getItemValueAsString("docid");
获取值时报错 Item docid's value can't get as string!
这个值我要如果读取

ID as docid 需要改为：ID as  item_docid
这样你才能用doc.getItemValueAsString("docid"); 获取

可以了，谢谢

感谢您的反馈。