|
版本: |
BeX5V3.5 |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
自定义了一个queryAction,源码如下:
select SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sFID as sFID,SA_OPOrg.sOrgKindID as sOrgKindID,SA_OPOrg.sParent as sParent
from SA_OPOrg SA_OPOrg
where SA_OPOrg.sValidState >= 0 AND SA_OPOrg in (select SA_OPOrg.sParent as sParent from SA_OPOrg SA_OPOrg where SA_OPOrg.sCode LIKE '%DWYH%')
order by SA_OPOrg.sSequence asc
在action中点测试,可查出数据,但是放到页面里就报ksql错误,sParent必须包含在select查出列中
|
|