Flette Pagingrecordset og clickcount.asp
Jeg har fundet scriptet clickcount.asp på flg adresse PÅhttp://www.activeserverpages.dk/download/default.asp?mode=showdownload&id=33
et lille script der kan tælle hvor mange gange en fil er blevet downloaded
Samtidig er der på http://www.activeserverpages.dk/aspdigital/kapitel2/paging.asp en demo af hvordan man pager et record set, jeg har brugt adskillige timer på at flette dem sammen uden held
Jeg bruger download.mdg databasen fra clickcount.asp scriptet, hidtil ser det således ud
<html><head>
<title>Paging af et recordset</title>
</head><body>
<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Download"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("download.mdb")
rs.Open strSQL, strDSN, 1
If Request.QueryString("id") <> "" Then
Set rs = Server.CreateObject("ADODB.RecordSet")
strLinkSQL = "SELECT * FROM Download WHERE (ID = " & Request.QueryString("id") & ")"
rs.Open strLinkSQL, myConn, 1, 3
If Not (rs.BOF Or rs.EOF) Then
rs("Hits") = rs("Hits") + 1
strURL = rs("URL")
rs.Update
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
Response.Clear
Response.Redirect(strURL)
End If
End If
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 "<p><a href=paging.asp?id=" & rs("ID") & ">" & rs("Navn") & "</a><br>"
Response.Write "<font size=-1>Hits: " & rs("Hits") & "</p>"
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
%>
</body></html>
Men jeg skal have tilføjet
<%
Response.Buffer = True
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("download.mdb")
If Request.QueryString("id") <> "" Then
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Download WHERE (ID = " & Request.QueryString("id") & ")"
rs.Open strSQL, myConn, 1, 3
If Not (rs.BOF Or rs.EOF) Then
rs("Hits") = rs("Hits") + 1
strURL = rs("URL")
rs.Update
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
Response.Clear
Response.Redirect(strURL)
End If
End If
%>
<html><head>
<title>Tælle downloads fra Database</title>
</head><body>
<p>DOWNLOAD</p>
<%
strSQL = "SELECT * FROM Download ORDER BY Navn"
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Do While Not rs.EOF
Response.Write "<p><a href=clickcount.asp?id=" & rs("ID") & ">" & rs("Navn") & "</a><br>"
Response.Write "<font size=-1>Hits: " & rs("Hits") & "</p>"
rs.Movenext
Loop
End If
myConn.Close
Set myConn = Nothing
%>
</body>
</html>
Så der både bliver talt download, og kun vist 10 poster af gangen
Jeg har selv prøvet uden held, er der nogen der vil Hjælpe
