hi,
my code was running fine till now.
But today i got an error "Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.
"
and my code is
set detail=Server.CreateObject("ADODB.RecordSet")
if Request.QueryString("val")<>"All" and Request.QueryString("val")<>"" then
qrydetail="select * from customer where allot='1' and manufacturer='"&request.QueryString("val")&"' and renewal_ins_date between '"&q&"' and '"&p&"' order by renewal_ins_date asc"
else
qrydetail="select * from customer where allot='1' and renewal_ins_date between '"&q&"' and '"&p&"' order by renewal_ins_date asc"
end if
Dim thisPage, rowcount, TotalPages, pgSise, RecCount
Const adOpenStatic = 3
thisPage = Trim(Request("thisPage"))
if thisPage = "" then thisPage = 1
detail.CursorType = adOpenStatic
detail.PageSize = 10
detail.Open qrydetail,objconn,1,3
if not detail.EOF then
detail.AbsolutePage = cINT(thisPage)
end if
TotalPages = detail.PageCount
pgSise = detail.PageSize
RecCount = detail.RecordCount
Where can be the problem?
Thanks in advance