ASP调用储存过程的问题
ASP页面:
<%
miao=timer
sl=request("sl")
slp=request("slp")
Cx=request("cx")
if sl="" then sl=0
if slp="" then slp=20
set recom = server.createobject("adodb.command")
recom.activeconnection = Conn
recom.commandtype = 4
recom.commandtext = "p"
ColName=20 '每页显示多少条记录
recom.Parameters.Append recom.CreateParameter("@ColName",202,1,100,ColName)
recom.Parameters.Append recom.CreateParameter("@Cx",202,1,,Cx)
recom.Parameters.Append recom.CreateParameter("@sl",3,1,,sl)
recom.Parameters.Append recom.CreateParameter("@slp",3,1,,slp)
set rs = recom.execute ()
%>
SQL 储存过程
CREATE PROCEDURE P
(
@ColName varchar(20), --显示多少条记录
@sl int,
@slp int,
@cx varchar(20)
)
AS
declare @sql varchar(100)
if @cx="" begin
set @sql="select top "+str(@ColName)+" id,text,riqi from aa where id>"+str(@sl)+" and id<"+str(@slp)+" order by id asc"
end
else begin
set @sql="select top "+str(@ColName)+" id,text,riqi from aa where riqi like '%"+@cx+"%' order by id asc"
end
exec(@sql)
GO
提示查不到记录。是不是调用储存过程有问题