strSQL = "SELECT LinkURL FROM Links" rs.Open strSQL, Conn,1
If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 10 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("LinkURL") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing
Response.Write "<p>Gå til side " For intNum = 1 To intPageCount Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> " Next
Response.Write "<p>" If Clng(intPage) > 1 Then Response.Write "<a href=paging.asp?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
If Clng(intPage) < Clng(intPageCount) Then Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
Nu er mine spørgsmål så: 1. Når jeg kommer op på x antal id'er vokser "Gå til side 1 2 3 4 5 6 7 8 osv..." Hvad skal koden hede for at der kun bliver vist fx 5 sider af gangen. "<< Gå til side 105 106 107 108 109 110 >>"
2. Hvordan får man vendt række følgen. Så den starter fra "Gå til side 110 109 108 107 106 105 >>"
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
strSQL = "SELECT LinkURL FROM Links" rs.Open strSQL, Conn,1
If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 10 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("LinkURL") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing
Response.Write "<p>Gå til side " '*************** ' Her '*************** For intNum = intPage - 5 To intPage + 5 Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> " Next
Response.Write "<p>" If Clng(intPage) > Clng(intPage -5) Then Response.Write "<a href=paging.asp?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
'********************** '** Næste linie ** '********************** If Clng(intPage) < Clng(intPage + 5) Then Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
På denne måde får du (skulle jeg mene) siderne der ligger 5 over og 5 under den side du befinder dig på vist.
Jeg kan ikke helt overskue det med at skifte om...
strSQL = "SELECT LinkURL FROM Links" rs.Open strSQL, Conn,1
If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("LinkURL") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing
Response.Write "<p>Gå til side " '*************** ' Her '*************** For intNum = intPage - 5 To intPage + 5 if intNum <= intPageCount AND intNum > 0 then Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> " end if Next
Response.Write "<p>" If Clng(intPage) > 1 Then Response.Write "<a href=paging.asp?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
'********************** '** Næste linie ** '********************** If Clng(intPage) < intPageCount Then Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
Mht. omvendt, så virker dette... <% intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If
strSQL = "SELECT LinkURL FROM Links" rs.Open strSQL, Conn,1
If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("LinkURL") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing
Response.Write "<p>Gå til side " '*************** ' Her '*************** intNum = intPage +5 while not intNum < intPage -5 if intNum <= intPageCount AND intNum > 0 then Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> " end if intNum = intNum -1 wend
Response.Write "<p>" If Clng(intPage) < intPageCount Then Response.Write "<a href=paging.asp?page=" & intPage + 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
'********************** '** Næste linie ** '********************** If Clng(intPage) > 1 Then Response.Write "<a href=paging.asp?page=" & intPage - 1 & ">>></a> " Else Response.Write ">>" End If %>
strSQL = "SELECT LinkURL FROM Links" rs.Open strSQL, Conn,1
If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount
Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("LinkUrl") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing
Response.Write "<p>Gå til side "
tal = intPageCount - intPage if not tal > 2 then tal = 4 - tal else tal = 2 end if
i = 0 For intNum = intPage - tal To intPage + 10 if i < 5 then 'if not intpage +2 > intpageCount then if intNum <= intPageCount AND intNum > 0 then i = i+1 if CInt(intPage) = CInt(intNum) then response.write "[" & intPage & "] " else Response.Write "<a href=paging.asp?page=" & intNum & ">" & intNum & "</a> " end if end if end if Next
Response.Write "<p>" If Clng(intPage) > 1 Then Response.Write "<a href=paging.asp?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If
Response.Write " "
If Clng(intPage) < intPageCount Then Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.