I know this question has been asked a million times, but I am doing paging where my table will consist of 10 records per page. My page is returning -1 and in the URL, page 2 is returning -2. I did put "Adopenstatic" as my cursortype. This is how I have it.....<BR><BR>&#039Create db connection and recordset objects<BR> &#039Open the connection string<BR> MyDSN="DSN=somename;UID=;PWD=;"<BR> Set DbObj = Server.CreateObject("ADODB.Connection")<BR> Set oRsjoin1 = Server.CreateObject("ADODB.Connection")<BR> Set oRsjoin2 = Server.CreateObject("ADODB.Connection")<BR> DbObj.Open MyDSN, adopenstatic<BR><BR>I have 2 recordsets. What am I doing wrong? Thanks 1 million times.