Sybase- Could not find SQL statement to include with refid 'getOrderInHdStatisDetailsql'

最新推荐文章于 2021-09-30 11:00:49 发布

恍然如梦_Bug

最新推荐文章于 2021-09-30 11:00:49 发布

阅读量741

点赞数

文章标签： Sybase Could not find SQL s

本文链接：https://blog.csdn.net/hw20101102/article/details/11966997

版权

要把<procedure>、<select> 放在 <sql >的后面，如下：

<sql id="getOrderYchdCountsql">
   select workid workId,
    orgrowid,
    orgName,
     dataValue,
     remark
  from order_ychd where alarmType = $alarmType$
and dateData >= '$startDate$'
   and dateData < '$endDate$'
]]>
</sql>

<procedure id="getOrderYchdByPage"
parameterClass="map"
resultClass="orderYchd">
{call ams_query_page('select aa.* from (
<include refid="getOrderYchdByPagesql" />
) aa ',$start$,$end$)}
</procedure>

<select id="getOrderYchdCount"
parameterClass="map"
resultClass="int">
select count(1) from (
<include refid="getOrderYchdCountsql" />
) sss
</select>