var t2 =FR.remoteEvaluate('=sql("DM","SELECT count(FID) from CT_RUBBISH_INFO where to_char(CREATETIME,'yyyy-MM-dd') =to_char(SYSDATE,'yyyy-MM-dd') AND FNAME=\''+a+'\'",1,1)'); 有个日期的转换该怎么修改,报错如下
var a = this.getValue();var b=FR.remoteEvalutate('sql("DM","SELECT FTYPE FROM CT_RUBBISH_ITEMS WHERE FNAME =\'"+ a +"\'",1,1)');_g().setCellValue('D6','', b);报错如下: