存取过程，出错，当前记录集不支持书签提示

[mofan4862]

当前记录集不支持书签。这可能是提供程序或选定的游标类型的限制
newsrs.open "exec cor_news_SelectAllwhere '"&keywords&"','"&txtCls&"','"&txtClsSun&"','"&userName&"'",strconn,1,1

[cqfeng]

strconn.execute("cor_news_SelectAllwhere '"&keywords&"','"&txtCls&"','"&txtClsSun&"','"&userName&"'") ?????

[mofan4862]

帮忙看一下，存取过程为：
CREATE PROCEDURE [dbo].[cor_news_SelectAllwhere]
@keywords varchar(20),
@txtCls int ,
@txtClsSun int,
@userName varchar(10)
--@ErrorCode int OUTPUT
AS

if @keywords="-1"
begin
SELECT
[ID],
[classid],
[son_classId],
[newstitle],
[newsimages],
[content],
[addtime],
[userName]
FROM [dbo].[news]

WHERE
[newstitle] like @keywords
end
---SELECT @ErrorCode=@@ERROR
GO

[Jaron]

set rs=server.createobject("adodb.recordset")
sql = "your_sp" & para
rs.CursorLocation = 3
rs.Open sql ,conn,1,1

try this..

[mofan4862]

奇怪，原先的可以用了

[lang11zi]

啊