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

Change the cursortype to adUseClient
>
>
>
>
>
vinod...@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.- Hide quoted text -
>
- Show quoted text -

Change the cursortype to adUseClient
>
>
>
>
>
vinod...@gmail.com wrote:>>>>>>>>>>