exec SOXU_Pagination
@PageSize
,@PageIndex
,@strGetFields=N '[SellID],[SortID],[Title] '
,@TableName=N '[T_Sell] '
,@DoCount=0
,@strOrder=N 'ORDER BY SellID DESC '
,@strWhere=N 'title like ' '% '[email protected]+ '% ' ' '
错误行----> ,@strWhere=N 'title like ' '% '[email protected]+ '% ' ' '
为什么呢?
------解决方案--------------------
存储过程参数不支持合成(+)参数:
set @strWhere=N 'title like ' '% '[email protected]+ '% ' ' '
exec SOXU_Pagination
@PageSize
,@PageIndex
,@strGetFields=N '[SellID],[SortID],[Title] '
,@TableName=N '[T_Sell] '
,@DoCount=0
,@strOrder=N 'ORDER BY SellID DESC '
,@strWhere