call storedprocdeure from asp

dear sir/madam

I have created a stored procedure using if and else if. this stored
procedure only select
record from table. and I have done paginh\g in asp page.
so It gives error
like

ADODB.Recordset error '800a0cb3'

Current Recordset does not support bookmarks. This may be a limitation
of the provider or of the selected cursortype.

/Tiecon/request_meet.asp, line 613

error line no is

rs.AbsolutePage = currentpage

I think calling of this stored proceudure is somethig different method
I m calling like this

rs.CursorType=adOpenStatic
rs.open sql,conn
pagecount = rs.pagecount

please tell me what is the problem

Thanks in advance

re: call storedprocdeure from asp

Change the cursortype to adUseClient

vinodkus@gmail.com wrote:--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

re: call storedprocdeure from asp

On Sep 25, 6:55*pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:sorry same error message display again

re: call storedprocdeure from asp

<vinodkus@gmail.comwrote in message
news:d1db095a-4a5a-4995-abf9-0b4903126958@a3g2000prm.googlegroups.com...
On Sep 25, 6:55 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:sorry same error message display againSince this an error to do with the provider do you think it might be an idea
to specify which provider you are using?

Are you sure a rowset is being returned form the SP?


--
Anthony Jones - MVP ASP/ASP.NET