Avatar billede mtm Praktikant
05. maj 2000 - 15:33 Der er 5 kommentarer og
1 løsning

hjælp til newbee...

Hej
Jeg har prøvet at sammenflette min ”Billeddatabase” med ”Paging af et recordset”
Problemet er at den ny side viser alle posterne på alle siderne
Er der en som kan se hvordan man kan få det til at vikke :-)
Da jeg desværre i øjeblikket kan finde ud af klippe / klistre :-(

x.asp:

<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Images ORDER BY ID DESC"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb")
rs.Open strSQL, strDSN, 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>"
%>

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb")
strSQL = "Select * From Images ORDER BY ID DESC"
Set RS = Conn.Execute(strSQL)
%>

<% Do While Not rs.EOF %>

<table border="0" cellpadding="0" cellspacing="4" width="350"
bgcolor="#000000" align="center">
<tr>
<td rowspan="3" width="35%"><a
href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td>
<td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td>
</tr>
<tr>
<td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td>
</tr>
<tr>
<td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td>
</tr>
</table>
<%
RS.MoveNext
Loop
%>
<% Do While Not rs.EOF And intRecCount > 0
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
%>
<%
Conn.Close
Set Conn = Nothing
%>
<%
If Clng(intPage) > 1 Then
Response.Write "<font size=-1><a href=x.asp?page=" & intPage - 1 & "> << Forrige side</a>"
Else
Response.Write ""
End If
Response.Write " "
For intNum = 1 To intPageCount
Response.Write "<font size=-1><a href=x.asp?page=" & intNum & ">< " & intNum & " ></a> "
Next
Response.Write " "
If Clng(intPage) < Clng(intPageCount) Then
Response.Write "<font size=-1><a href=x.asp?page=" & intPage + 1 & ">Næste side >></a> "
Else
Response.Write ""
End If
%>

Avatar billede mtm Praktikant
05. maj 2000 - 15:40 #1
det er disse 2 filer:
1:<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT Navn FROM Images ORDER BY ID DESC"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb")
rs.Open strSQL, strDSN, 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("Navn") & "<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=x4.asp?page=" & intNum & ">" & intNum & "</a> "
Next
Response.Write "<p>"
If Clng(intPage) > 1 Then
Response.Write "<a href=x4.asp?page=" & intPage - 1 & ">&lt;&lt;</a>"
Else
Response.Write "&lt;&lt;"
End If
Response.Write "&nbsp;"
If Clng(intPage) < Clng(intPageCount) Then
Response.Write "<a href=x4.asp?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
Response.Write "&gt;&gt;"
End If
%>
Avatar billede mtm Praktikant
05. maj 2000 - 15:41 #2
2:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb")
strSQL = "Select * From Images ORDER BY ID DESC"
Set RS = Conn.Execute(strSQL)
%>

<% Do While Not rs.EOF %>

<table border="0" cellpadding="0" cellspacing="4" width="350"
bgcolor="#C0C0C0" align="center">
    <tr>
        <td rowspan="3" width="35%"><a
        href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td>
        <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td>
    </tr>
</table>
<%
RS.MoveNext
Loop
%><%
Conn.Close
Set Conn = Nothing
%>
Avatar billede elk Nybegynder
05. maj 2000 - 15:44 #3
Hvorfor har du

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb")
strSQL = "Select * From Images ORDER BY ID DESC"
Set RS = Conn.Execute(strSQL)
%>

dobbelt ???
Avatar billede ricardo Nybegynder
05. maj 2000 - 16:36 #4
Paging er ikke for begyndere!
Avatar billede mtm Praktikant
05. maj 2000 - 19:28 #5
nye x.asp ser sådan ud:
<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Images ORDER BY ID DESC"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb")
rs.Open strSQL, strDSN, 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 %>

<table border="0" cellpadding="0" cellspacing="4" width="350" align="center">
    <tr>
        <td rowspan="3" width="35%"><a
        href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td>
        <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td>
    </tr>
</table>
<%
RS.MoveNext
Loop
%><% Do While Not rs.EOF And intRecCount > 0
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
%>
<%
If Clng(intPage) > 1 Then
Response.Write "<font size=-1><a href=x4.asp?page=" & intPage - 1 & "> &lt;&lt; Forrige side</a>"
Else
Response.Write ""
End If
Response.Write "&nbsp;"
For intNum = 1 To intPageCount
Response.Write "<font size=-1><a href=x4.asp?page=" & intNum & ">< " & intNum & " ></a> "
Next
Response.Write "&nbsp;"
If Clng(intPage) < Clng(intPageCount) Then
Response.Write "<font size=-1><a href=x4.asp?page=" & intPage + 1 & ">Næste side &gt;&gt;</a> "
Else
Response.Write ""
End If
%>
men den viser stadig væk alle postene på alle siderne...
Avatar billede mtm Praktikant
05. maj 2000 - 20:11 #6
jeg fik det at vikke :-)
sådan=
<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM Images ORDER BY ID DESC"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb")
rs.Open strSQL, strDSN, 1
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 5
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
Response.Write "<b>Side " & intPage & " af " & intPageCount & "</b>"
%><hr>
<% Do While Not rs.EOF And intRecCount > 0 %>

<table border="0" cellpadding="0" cellspacing="4" width="350" align="center">
    <tr>
        <td rowspan="3" width="35%"><a
        href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td>
        <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td>
    </tr>
    <tr>
        <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td>
    </tr>
</table>
<hr><%
intRecCount = intRecCount - 1
RS.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
%>
<div align="center"><%
If Clng(intPage) > 1 Then
Response.Write "<font size=-1><a href=x4.asp?page=" & intPage - 1 & "> &lt;&lt; Forrige</a>"
Else
Response.Write ""
End If
Response.Write "&nbsp;"
For intNum = 1 To intPageCount
Response.Write "<font size=-1><a href=x4.asp?page=" & intNum & ">" & intNum & "</a> "
Next
Response.Write "&nbsp;"
If Clng(intPage) < Clng(intPageCount) Then
Response.Write "<font size=-1><a href=x4.asp?page=" & intPage + 1 & ">Næste &gt;&gt;</a> "
Else
Response.Write ""
End If
%></div>
Avatar billede Ny bruger Nybegynder

Din løsning...

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.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester