获取数据库表单数据

Field:姓名-值脚本出错 <br>JavaScriptRunning:[Form.PerInformation.Field(11e0-72f1-fb8c0fe9-bd8d-838ba28694b8).姓名.ValueScript]: unterminated string literal (Form.PerInformation.Field(11e0-72f1-fb8c0fe9-bd8d-838ba28694b8).姓名.ValueScript#1)  


脚本值
var sql="select id as id,姓名 as ITEM_姓名, '"+getWebUser().getDomainid()+"'

domainid  from tlk_perinformation ";
var opts = $TOOLS.createOptions();
var query = queryBySQL(sql);
var value = "";
if(query!=null)
{
  for(var iter = query.iterator();iter.hasNext();){
  var doc= iter.next();
  value= doc.getItemValueAsString("ITEM_姓名");
  opts.add(id,value);
  }  
}
opts;

var sql="select id as id,姓名 as ITEM_姓名, '"+getWebUser().getDomainid()+"'  
你把这条语句改成这样试试：
var sql="select  id,ITEM_姓名 as 姓名,domainid from tlk_perinformation "

回复 2# kimi

还是不行
*Field:姓名-值脚本出错 <br>JavaScriptRunning:[Form.PerInformation.Field(11e0-72f1-fb8c0fe9-bd8d-838ba28694b8).姓名.ValueScript]: missing ; before statement (Form.PerInformation.Field(11e0-72f1-fb8c0fe9-bd8d-838ba28694b8).姓名.ValueScript#2)

您好：您可以通过如下代码实现：
sql="select item_姓名,id,domainid from tlk_perinformation";
var datas = queryBySQL(sql);
for (var iter = datas.iterator(); iter.hasNext();) {
var  doc= iter.next();
value = doc.getItemValueAstring("item_姓名");
}
value;