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

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

恍然如梦_Test

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

阅读量633

点赞数

分类专栏： Sybase 文章标签： sybase

本文链接：https://blog.csdn.net/u012228219/article/details/11968383

版权

Sybase 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

要把<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>