急求！！asp调用存储过程代码？ 为什么我的代码显示不出来，好像根本没调用存储过程？？？

[wendy1208]

以下是我用的代码，可是好像根本没有调用存储过程，不知道代码有什么问题？希望得到正确的能调用存储过程的方法！

set CmdSP = Server.CreateObject("ADODB.Command")
CmdSP.ActiveConnection ="Provider = Sqloledb; User ID =ss; Password = ss; Initial Catalog = database; Data Source = (local); database=database"
CmdSP.CommandText = "COM_SEARCH"
CmdSP.CommandType = 4
CmdSP.Parameters.Append CmdSP.CreateParameter("@vchXL", 200, 1, 40, request.form("search_xl"))
CmdSP.Parameters.Append CmdSP.CreateParameter("@vchDepart", 200, 1, 80, request.form("search_depart"))'
CmdSP.Parameters.Append CmdSP.CreateParameter("@age", 3, 1, ,request.form("Age"))
Set adoRS = CmdSP.Execute

请大侠们多多帮忙，万分感谢！

[wendy1208]

附加一句，在这个过程中调用的是2个表的数据！

[wendy1208]

请大家多帮忙！
自己顶~

[tigerwen01]

CmdSP.Parameters.Append CmdSP.CreateParameter("@age", 3, 1, ,request.form("Age"))
好象多一个，号

[arrowy]

CmdSP.ActiveConnection ="Provider = Sqloledb; User ID =ss; Password = ss; Initial Catalog = database; Data Source = (local); database=database"
换成
CmdSP.ActiveConnection = objconn (就是用一个活动的connection对象）

试试呢

[wendy1208]

试了，都没什么用。
对了，顺便问一下：存储过程调用后取出的记录集能用AbsolutePage这个属性吗？
如果不能，有什么简单的方法能解决？
多谢！
得到答案后马上结帖～

[笨笨兔兔兔兔兔]

CREATE PROCEDURE dbo.picdisplay
@foldernum int,
@id int,
@page int,
@totalpage int output
AS
declare @thepage int
declare @pagenum int
declare @sql nvarchar(200)
set @thepage=(@page-1)*4
if @foldernum=0
begin
set @sql='select top 4 * from pic where id='
+cast(@id as nvarchar(30)) +'and thepicid not in
(select top '+cast(@thepage as nvarchar(30))+'
thepicid from pic where id='+cast(@id as nvarchar(30))+'
order by thepicid) order by thepicid'
exec sp_executesql @sql
select @pagenum=count(*) from pic where id=@id

if (@pagenum % 4)=0
begin
select @totalpage=@pagenum/4
end
else
begin
select @totalpage=@pagenum/4+1
end


end
else
if @foldernum=1
begin
set @sql='select top 4 * from pic where id='
+cast(@id as nvarchar(30)) +'and share=1 and thepicid not in
(select top '+cast(@thepage as nvarchar(30))+'
thepicid from pic where id='+cast(@id as nvarchar(30))+' and share=1
order by thepicid) order by thepicid'
exec sp_executesql @sql
select @pagenum=count(*) from pic where id=@id and share=1
if (@pagenum % 4)=0
begin
select @totalpage=@pagenum/4
end
else
begin
select @totalpage=@pagenum/4+1
end
end
else
if @foldernum=2
begin
set @sql='select top 4 * from pic where id='
+cast(@id as nvarchar(30)) +'and foldernum=0 and thepicid not in
(select top '+cast(@thepage as nvarchar(30))+'
thepicid from pic where id='+cast(@id as nvarchar(30))+' and foldernum=0
order by thepicid) order by thepicid'
exec sp_executesql @sql
select @pagenum=count(*) from pic where id=@id and foldernum=0
if (@pagenum % 4)=0
begin
select @totalpage=@pagenum/4
end
else
begin
select @totalpage=@pagenum/4+1
end
end
else
begin
set @sql='select top 4 * from pic where id='
+cast(@id as nvarchar(30)) +'and foldernum='+cast(@foldernum as nvarchar(30))+' and thepicid not in
(select top '+cast(@thepage as nvarchar(30))+'
thepicid from pic where id='+cast(@id as nvarchar(30))+' and foldernum='+cast(@foldernum as nvarchar(30))+'
order by thepicid) order by thepicid'
exec sp_executesql @sql
select @pagenum=count(*) from pic where id=@id and share=1
if (@pagenum % 4)=0
begin
select @totalpage=@pagenum/4
end
else
begin
select @totalpage=@pagenum/4+1
end
end
GO

我的分页存储过程不算很好,你自己看看吧