记录一个hql错误
程序员文章站
2022-07-11 10:54:07
...
Incorrect query syntax [
select
t.id,t.busFlowID,t.entName,t.leRep,t.type,t.entTypePro,t.entType,t.dom,t.tel,t.accDate,t.state,t.busID
from
com.topsoft.domain.icis.reg.entxml.entity.EntActInfoXML t
where
t.state in ('01','02','04','12','91','03')
and (t.accOrgID=152011500000000 or t.apprOrgID=152011500000000)
and t.busType='01'
and t.type = '2100'
and t.entName like '%' = '%'
and not exists (
select
t.id
from
com.topsoft.domain.icis.reg.register.entity.IndSimpleEstRecord s
where
s.actBusFlowId = t.busFlowID
)
]
select
t.id,t.busFlowID,t.entName,t.leRep,t.type,t.entTypePro,t.entType,t.dom,t.tel,t.accDate,t.state,t.busID
from
com.topsoft.domain.icis.reg.entxml.entity.EntActInfoXML t
where
t.state in ('01','02','04','12','91','03')
and (t.accOrgID=152011500000000 or t.apprOrgID=152011500000000)
and t.busType='01'
and t.type = '2100'
and t.entName like '%' = '%'
and not exists (
select
t.id
from
com.topsoft.domain.icis.reg.register.entity.IndSimpleEstRecord s
where
s.actBusFlowId = t.busFlowID
)
]
上一篇: “想当年我在江苏上班的时候
下一篇: C# 客户端程序自动更新