获取表中的ID

值脚本如下：
var value = getItemValue("outboundno");
var applicationno = "AP1407230004";
var sql = "select ID as  item_docid from TLK_FM_APPLICATION where ITEM_APPLICATIONNO = '"+applicationno+"'";
var docs =  queryBySQL(sql);
for (var iter = docs.iterator(); iter.hasNext();) {
     var doc =  iter.next();
     value = doc.getItemValueAsString("docid");
}
value;
想获取表中的ID（默认的那个ID）

前台出错

java.lang.Exception: Fieldutboundno-值脚本出错 <br>JavaScriptRunning:[Form.fm_outbound.Field(11e4-123b-4285e94d-a8f7-69173e7e387c).outboundno.ValueScript]: Wrapped com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'table_0.DOMAINID' in 'where clause' (baselib#1247)        at cn.myapps.core.dynaform.activity.ejb.type.DocumentCreate.doExecute(DocumentCreate.java:87)
        at cn.myapps.core.dynaform.activity.ejb.Activity.execute(Activity.java:1442)
        at cn.myapps.core.dynaform.activity.action.ActivityRunTimeAction.doAction(ActivityRunTimeAction.java:281)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)

你好 ，要获取表单ID 如果你的sql 返回的是多条记录：
var docID ="";
var sql ="select * from tlk_XX where item_XX ='"+XX+"'";
var datas = queryBySQL(sql);
if(datas !=null && datas.size()>0){
        for (var iter = docs.iterator(); iter.hasNext();) {
                 var doc =  iter.next();
                        docID = doc.getId();        //获取当前表单ID；
        }                 
}
docID;

如果是返回的是一条记录则用如下代码
var docID ="";
var sql ="select * from tlk_XX where item_XX ='"+XX+"'";
var datas = findBySQL(sql);
        if(datas !=null){
                 docID = doc.getId();        //获取当前表单ID；
        }
docID;

回复 2# sukula


    谢谢……结贴

感谢楼主回复，该贴结贴