新建一个视图,数据中为代码sql:
var domainid =getDomainid();
var sql="SELECT '"+domainid+"' as domainid,a.ITEM_CNUMBER, a.ITEM_CDATE,a.ITEM_CNUM,a.ITEM_CYEWU,a.ITEM_CYEWUQITA,a.ITEM_CZHENGSHUQIXIAN,a.ITEM_CZHENGSHUQITA,a.ITEM_CQITA,a.ITEM_CQITATYPE,a.ITEM_CQITAJIEZHI, a.ITEM_CZHENGSHUJIGOU,a.ITEM_CTYPE,a.ITEM_CTYPE2,a.ITEM_CJIEZHI,a.ITEM_CSUANFA,a.ITEM_CDN,a.ITEM_CYOUXIANG,a.ITEM_CBUMENMINGCHENG,a.ITEM_XITONGMINGCHENG,a.ITEM_CSHIYOU,a.ITEM_CFWQYWLX,a.ITEM_CIPADDRESS,a.ITEM_CPORT,a.ITEM_CGESHI,a.ITEM_CTIJIAOWENJIAN,a.ITEM_CBUMENFUZUREN,a.ITEM_CBUMENFUZERENDATE,a.ITEM_CSHENHEREN,a.ITEM_CSHENHEDATE,a.ITEM_CSHENHEYIJIAN,a.ITEM_CJINGBANREN,a.ITEM_CJINGBANDATE,a.ITEM_CSUANFA2,a.ITEM_CCAXINXI,a.ITEM_ZHONGJICA,a.ITEM_CBEIZHU,a.ITEM_CAQITA,a.ITEM_QITAZHONGJICA,a.ITEM_CPORTQITA,b.ITEM_CMIMA,b.ITEM_CXULIE,b.ITEM_CYOUXIAOQI1,b.ITEM_CYOUXIAOQI2,b.ITEM_SENDYJ,b.ITEM_ZHENGSHUDN,c. NAME AS item_name FROM tlk_certificate_apply a, tlk_certificate_apply_detailed b, bpm.t_user c WHERE a.id = b.PARENT AND a.ITEM_CSHENQINGREN = c.ID ";
println("sql----"+sql);
sql;
然后去列里面,把sql中查询到的列都添加上,会报错,烦请按照我的操作在试一遍;
还有,可以把你刚刚发的地址的前台以及后台的登录账号和密码发给我一下嘛,不然我无法测试。
|