|
|
本帖最后由 shary 于 2012-5-23 18:56 编辑
var sql="select * from TLK_CONTRACT_MAIN where ITEM_IF_TRY= '试用' and DateDiff('"+format(getToday(),"yyyy-MM-dd ")+"',ITEM_OVER_SHIYONG)<7";
var datas = queryBySQL(sql);
var process = getDocumentProcess();
var formProcess = getFormProcess();
//表单ID值。可以通过数据库客户端查看那张表的formid字段值就可以。
var subform = formProcess.doView("11e1-3075-5a8e7df1-bc72-3be80e04a245");
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var ht_type="";
var Sign_date;
var ht_name="";
var over_ShiYong;
println("输出一下SQL:"+sql);
for(var iter = datas.iterator();iter.hasNext();){
println("循环里面呢!");
var doc1 = iter.next();
if(doc1!=null){
ht_type=doc1.getItemValueAsString("ht_type");
println("输出一下"+ht_type);
Sign_date=doc1.getItemValueAsDate("Sign_date");
println("输出一下"+ Sign_date);
ht_name=doc1.getItemValueAsString("ht_name");
println("输出一下"+ht_name);
over_ShiYong=doc1.getItemValueAsDate("over_ShiYong");
println("输出一下"+over_ShiYong);
doc.addStringItem("ht_type",ht_type);
doc.addDateItem("Sign_date",Sign_date);
doc.addStringItem("ht_name",ht_name);
doc.addDateItem("ht_DateDue",over_ShiYong);
process.doCreate(doc);
}
}
报了这样一个错误麻烦帮我检查一下
org.mozilla.javascript.WrappedException: Wrapped com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ITEM_ht_DateDue' in 'field list' (11e1-942b-27c67e99-963c-07e0b0b76d19).保存afterActionScript#43) |
|