Actually i am trying to display 5 records in a page and giving link to other pages like,<BR><BR>25 Records found.<BR><BR>(1-5) (6-10) (11-15) (16-20) (21-25)<BR><BR>Page 1<BR>---------------------<BR>1.First Record.<BR><BR>2. Second record<BR><BR>3. Third Record <BR><BR>4. Fourth Record.<BR><BR>5. Fifth Record.<BR>---------------------<BR><BR>When I click (6-10) link It should display Next 5 records,…..<BR><BR><BR>For the above I tried like.<BR>&#060;%<BR>DIM currentPage, rowCount, i<BR>currentPage = TRIM( Request( "currentPage" ) )<BR>if currentPage = "" then currentPage = 1<BR>set DBConn = server.createobject("adodb.connection")<BR>DBConn. open "dsn=portdsn;uid=sa;pwd=;database=PortDB"<BR>S et MemDisRS = Server.CreateObject("ADODB.Recordset")<BR>MemDisRS .CursorType = adOpenStatic<BR>MemDisRS.PageSize = 5<BR>MemDisRS.Open "select * from table1 order by no", DBConn<BR>Response.write "Current Page Value is :"<BR>Response.write currentPage<BR>Response.Write "<BR><BR>"<BR>MemDisRS.AbsolutePage = cINT( currentPage )<BR>rowCount = 0<BR>x1="hi"<BR>While not MemDisRS.EOF and rowCount &#060; MemDisRS.PageSize<BR>Response.Write MemDisRS(0)<BR>Response.Write "<BR>"<BR>rowCount = rowCount + 1 <BR>MemDisRS.MoveNext<BR>Wend<BR> Response.Write "&#060;hr&#062;"<BR> for i = 1 to MemDisRS.PageCount<BR> %&#062;&#060;a href="TradersDisplayTest1.asp?currentPage=&#060;%= i%&#062;"&#062;&#060;%=i%&#062;&#060;/a&#062; &#060;% <BR> next<BR>%&#062;<BR><BR><BR>It is giving the following Error. <BR><BR>--<BR>ADODB.Recordset error &#039;800a0cb3&#039; <BR>Object or provider is not capable of performing requested operation. <BR>Tradersdiaplaytest1.asp line 18.<BR>--<BR><BR>Line no 18 is: <BR><BR>MemDisRS.AbsolutePage = cINT( currentPage )<BR><BR>I think MemDisRS.AbsolutePage is giving error. Because I tried to display the Recordscount. But it is returning -1(minus one). But in Database 25 recirds are there.