|
本帖最后由 leiming01 于 2013-10-11 16:46 编辑
执行ksql:select OA_OfficeBoxApply_C.fCreatDept as fCreatDept,OA_OfficeBoxApply_C.fOfficeBoxName as fOfficeBoxName,OA_OfficeBoxApply_C.fDJ as fDJ,sum(OA_OfficeBoxApply_C.fYSQL) as fYSQL
from OA_OfficeBoxApply_C OA_OfficeBoxApply_C
where OA_OfficeBoxApply_C.fCreatDept = :dept
AND OA_OfficeBoxApply_C.fSQSJ >= stringToDateTime( :startDate )
AND OA_OfficeBoxApply_C.fSQSJ <= stringToDateTime( :endDate )
group by OA_OfficeBoxApply_C.fCreatDept, OA_OfficeBoxApply_C.fOfficeBoxName, OA_OfficeBoxApply_C.fDJ时出错!
上面这个kql语句错了,怎么改啊,其中dept、startDate、endDate是传来的参数
|
|