SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru
    Join Date
    Aug 2004
    Location
    Canada
    Posts
    730
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    why some records don't show

    http://freehost02.websamba.com/bible...s&optAction=on

    This is page 1 Do you see any records? I think you do.
    Click page 95. Now do you see any records?

    This is what I have:
    Code:
    <%
    if pagecnt>2 then
       for i=1 to pagecnt
       pagingurl = "<a href=""" & Request.ServerVariables("SCRIPT_NAME") & "?page=" & i
                       If Keyword <> "" Then
                          pagingurl = pagingurl & "&keyword=" & Keyword
                       End If
                       If Keywordb <> "" Then
                          pagingurl = pagingurl & "&keywordb=" & Keywordb
                       End If
                       If Keywordc <> "" Then
                          pagingurl = pagingurl & "&keywordc=" & Keywordc
                       End If
                       If Keywordd <> "" Then
                          pagingurl = pagingurl & "&keywordd=" & Keywordd
                       End If
                       If Keyworde <> "" Then
                          pagingurl = pagingurl & "&keyworde=" & Keyworde
                       End If
                       If Keywordf <> "" Then
                          pagingurl = pagingurl & "&keywordf=" & Keywordf
                       End If
    
                       If number<> "" then
                          If   request.QueryString("book")="yes" then pagingurl = pagingurl & "&book=yes" & "&number=" & number
                          If   request.QueryString("chapter")="yes" then pagingurl = pagingurl & "&chapter=yes" & "&number=" & number
                          If   request.QueryString("verse")="yes" then pagingurl = pagingurl & "&verse=yes" & "&number=" & number
                          If   request.QueryString("bookchapter")="yes" then pagingurl = pagingurl & "&bookchapter=yes" & "&number=" & number
                          If   request.QueryString("chapterverse")="yes" then pagingurl = pagingurl & "&chapterverse=yes" & "&number=" & number
                          If   request.QueryString("bookchapterverse")="yes" then pagingurl = pagingurl & "&bookchapterverse=yes" & "&number=" & number
                          If   request.QueryString("gemetria")="yes" then pagingurl = pagingurl & "&gemetria=yes" & "&number=" & number
    
                       End If
    
                       If spoke<> "" then
                          If   request.QueryString("book_spoke")="Book_Spoke" then pagingurl = pagingurl & "&book_spoke=Book_Spoke" & "&spoke=" & spoke
                          If   request.QueryString("chapter_spoke")="Chapter_Spoke" then pagingurl = pagingurl & "&chapter_spoke=Chapter_Spoke" & "&spoke=" & spoke
                          If   request.QueryString("verse_spoke")="Verse_Spoke" then pagingurl = pagingurl & "&verse_spoke=Verse_Spoke" & "&spoke=" & spoke
                       End if
    
                       If hInput <> "" then 
                          pagingurl = pagingurl & "&hInput=" & hInPut
                       End If
                       If hOutput <> "" then
                          pagingurl = pagingurl & "&hOutput=" & hOutPut
                       End If
    
                       If Trim(Request.QueryString("recordType")) <> "" then
                          aRecTypes = Split(Request.QueryString("recordType"), ",")
                                    For iLoopCount = 0 To UBound(aRecTypes)
                                        pagingurl = pagingurl & "&recordType=" & trim(aRecTypes(iLoopCount))
                                    Next
                       End If
       pagingurl = pagingurl & "&text_data=yes" & "&optAction=on"">"&i&"</a> "
       response.write pagingurl
       Response.Write "&nbsp;|&nbsp;"
       next
    end if
    %>
    Compare bible texts (and other tools):
    TheWheelofGod

  2. #2
    SitePoint Addict phpster's Avatar
    Join Date
    Feb 2005
    Location
    Toronto, Canada
    Posts
    374
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    probably because the array is 0 based and your record count is one based, you are going one page to far
    phpster

    I wish my computer would do what I want it to.
    Not what I tell it to do...

  3. #3
    SitePoint Enthusiast afgmail's Avatar
    Join Date
    Jan 2005
    Location
    Houston, TX
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Change:
    Code:
    for i=1 to pagecnt
    to:
    Code:
    for i=0 to pagecnt
    Scan completed....
    Brain not found.
    filecabin.com : Notepad2


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •