Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: recordcount and pagecount are giving me -1


Message #1 by "Rick Feuer" <rfeuer@h...> on Thu, 8 Mar 2001 00:08:36
I'm seeing this problem come up with other programmers I have fixed 

everything that I can see and I still am getting -1 value for pagecount.I 

am programming on windows 2000 server with access 2000. Here is my



Set rsData = Server.CreateObject("ADODB.Recordset")



  ' set the page size

  rsData.PageSize = 10

  rsData.CursorLocation = adUseClient



  ' open the data

rsData.Open "registration",CONNSTRING_,adOpenStatic,adLockReadOnly,

adCmdTable



 ' get the requested data

  If Request.QueryString("PAGE") = "" Then

    iPage = 1

  Else

    ' protect against out of range pages, in case

    ' of a user specified page number

    If iPage < 1 Then

      iPage = 1

    Else

      If iPage > rsData.PageCount Then

        iPage = rsData.PageCount

      Else

        iPage = CInt(Request.QueryString("PAGE"))

      End If

    End If

  End If



  ' set the page

  rsData.AbsolutePage = iPage

  response.write(rsData.PageCount)


  Return to Index