Avatar billede gnuffel Nybegynder
15. september 2003 - 18:23 Der er 12 kommentarer og
1 løsning

Sider i databasekald

Hej exp'ere!

Jeg har en tagwall/gb jeg gerne vil have lavet nogen sider i, sådan så at der står 15 indlæg pr. side, hvordan gør jeg det?


<%
Response.Buffer = True

Set Con = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("gb.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

    Sql = "SELECT * FROM beskeder ORDER BY ID DESC"
    Set Record =  Con.Execute(Sql)

%>
<html>
<head>
<style><!--a:hover{color:00BAFF; font-style:italic; }--></style>
</head>

<%
Do While Not Record.EOF

    besked = record("besked")
    besked = Replace(besked,"ok<ok","<")
    besked = Replace(besked,"ok>ok",">")
    besked = Replace(besked,"<","&lt;")
    besked = Replace(besked,">","&gt;")

%>

<% response.write Record("mail")%>
<% response.write Record("HP")%>
<% response.write Record("dato")%>
<% response.write Record("tid")%>
<% Response.Write besked %>
<%
Record.MoveNext
Loop
%>
<%
Con.Close
Set Con = Nothing
%>
Avatar billede Slettet bruger
15. september 2003 - 18:38 #1
prøv det her...

<%
if request.querystring("nr") = "" then
  nr = 1
else
  nr = request.querystring("nr")
end if


Response.Buffer = True

Set Con = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("gb.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

    Sql = "SELECT * FROM beskeder ORDER BY ID DESC LIMIT BY " & nr & ",15"
    Set Record =  Con.Execute(Sql)

%>
<html>
<head>
<style><!--a:hover{color:00BAFF; font-style:italic; }--></style>
</head>

<%
Do While Not Record.EOF

    besked = record("besked")
    besked = Replace(besked,"ok<ok","<")
    besked = Replace(besked,"ok>ok",">")
    besked = Replace(besked,"<","&lt;")
    besked = Replace(besked,">","&gt;")

%>

<% response.write Record("mail")%>
<% response.write Record("HP")%>
<% response.write Record("dato")%>
<% response.write Record("tid")%>
<% Response.Write besked %>
<%
Record.MoveNext
Loop
response.write "<br>"
if request.querystring("nr") > 15 then
response.write "<a href='detdinfilhedder.asp?nr=" & nr-15 & "'>sidste 15</a>"
end if
response.write "<a href='detdinfilhedder.asp?nr=" & nr+15 & "'>næste 15</a>"
%>
<%
Con.Close
Set Con = Nothing
%>
Avatar billede keysersoze Guru
15. september 2003 - 18:41 #2
kvadratrodenaf1 >> din kode vil ikke virke - man kan ikke lave paging på den måde i Access...

gnuffel >> det du søger hedder "paging" - og er forholdsvis lige til at gå til hvis du følger denne guide; http://activedeveloper.dk/aspdigital/kapitel2/paging.asp
Avatar billede gnuffel Nybegynder
15. september 2003 - 18:56 #3
Keyseroze> Kan du omskrive min source til at gøre det på den måde?
Hele koden jeg gerne vil have omskrevet er:

<%
Response.Buffer = True

Set Con = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("gb.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

    Sql = "SELECT * FROM beskeder ORDER BY ID DESC"
    Set Record =  Con.Execute(Sql)

%>
<html>
<head>
<style><!--a:hover{color:00BAFF; font-style:italic; }--></style>
</head>

<%
Do While Not Record.EOF

    besked = record("besked")
    besked = Replace(besked,"ok<ok","<")
    besked = Replace(besked,"ok>ok",">")
    besked = Replace(besked,"<","&lt;")
    besked = Replace(besked,">","&gt;")

%>
<b><font face="verdana" size="1" color="black">Skrevet af&nbsp;</body><font face="verdana" size="1" color="black"><a style="text-decoration: none" href="mailto:<% response.write Record("mail")%>"><font face="verdana" size="1" color="black"><% Response.Write Record("navn")%></a>&nbsp;|&nbsp;<a style="text-decoration: none; a:hover{color:00BAFF; font-style:italic; }" target="_top"  href="linkbooster?page=<% response.write Record("HP")%>"><font face="verdana" size="1" color="black"><% response.write Record("HP")%></a> </b>
<font face="verdana" size="1" color="black"><br>D.<% response.write Record("dato")%>&nbsp;klokken&nbsp;<% response.write Record("tid")%><br></font></b></b>
<font size="1"><br></font>
<font face="verdana" size="2" color="black"><% Response.Write besked %>
<br>
<table border="1" width="100%" style="border-width: 0px" bgcolor="#000000" cellspacing="0" cellpadding="0">
    <tr>
        <td style="border-style: none; border-width: medium">
        <span style="font-size: 1pt">&nbsp;</span></td>
    </tr>
</table><br>
<%
Record.MoveNext
Loop
%>
<font size="2" face="Verdana" color="#FFCC99">
<a href="?AnaGB=admin"><font size="1" color="black">Admin Login</font></a><font size="2" face="verdana">
</font>
</font>
</font>
<font size="2" face="verdana" color="#FFCC99">
<font size="2" face="verdana">
<%
Con.Close
Set Con = Nothing
%>


Håber du gider, jeg er nemlig ret _skod_ til den slags!
Avatar billede keysersoze Guru
15. september 2003 - 18:58 #4
Jeg kan godt men det er ikke noget jeg vil gøre for point - sorry
Avatar billede fbhzone Nybegynder
15. september 2003 - 19:14 #5
k
Avatar billede fbhzone Nybegynder
15. september 2003 - 19:15 #6
hov!
Kan du ik prøve og kigge på det link der er blevet sendt, det ser nu rimelig nemt ud!
Avatar billede eagleeye Praktikant
15. september 2003 - 19:16 #7
Jeg vil gerne give et bud på koden hvis du har lyst?
Avatar billede eagleeye Praktikant
15. september 2003 - 19:21 #8
<%
Response.Buffer = True

Set Con = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("gb.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
    intPage = 1
End If
Set Record = Server.CreateObject("ADODB.RecordSet")
Sql = "SELECT * FROM beskeder ORDER BY ID DESC"
Record.Open Sql, Con,1

%>
<html>
<head>
<style><!--a:hover{color:00BAFF; font-style:italic; }--></style>
</head>

<%

If Not (rs.BOF Or rs.EOF) Then
  rs.PageSize = 10
  rs.AbsolutePage = intPage
  intRecCount = rs.PageSize
  intPageCount = rs.PageCount

  Do While Not rs.EOF And intRecCount > 0

    besked = record("besked")
    besked = Replace(besked,"ok<ok","<")
    besked = Replace(besked,"ok>ok",">")
    besked = Replace(besked,"<","&lt;")
    besked = Replace(besked,">","&gt;")

%>
<b><font face="verdana" size="1" color="black">Skrevet af&nbsp;</body><font face="verdana" size="1" color="black"><a style="text-decoration: none" href="mailto:<% response.write Record("mail")%>"><font face="verdana" size="1" color="black"><% Response.Write Record("navn")%></a>&nbsp;|&nbsp;<a style="text-decoration: none; a:hover{color:00BAFF; font-style:italic; }" target="_top"  href="linkbooster?page=<% response.write Record("HP")%>"><font face="verdana" size="1" color="black"><% response.write Record("HP")%></a> </b>
<font face="verdana" size="1" color="black"><br>D.<% response.write Record("dato")%>&nbsp;klokken&nbsp;<% response.write Record("tid")%><br></font></b></b>
<font size="1"><br></font>
<font face="verdana" size="2" color="black"><% Response.Write besked %>
<br>
<table border="1" width="100%" style="border-width: 0px" bgcolor="#000000" cellspacing="0" cellpadding="0">
    <tr>
        <td style="border-style: none; border-width: medium">
        <span style="font-size: 1pt">&nbsp;</span></td>
    </tr>
</table><br>
<%
    Record.MoveNext
    intRecCount = intRecCount - 1
  Loop
end if
%>

<%
Response.Write "<table><tr>"
Response.Write "<td align=""center"">Gå til side<br> "
For intNum = 1 To intPageCount
    Response.Write "<a href=?page=" & intNum & ">" & intNum & "</a> "
Next
Response.Write "</td></tr><tr><td align=""center"">"
If Clng(intPage) > 1 Then
    Response.Write "<a href=?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=?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
    Response.Write "&gt;&gt;"
End If
Response.Write "</td></tr></table>"
%>

<font size="2" face="Verdana" color="#FFCC99">
<a href="?AnaGB=admin"><font size="1" color="black">Admin Login</font></a><font size="2" face="verdana">
</font>
</font>
</font>
<font size="2" face="verdana" color="#FFCC99">
<font size="2" face="verdana">
<%
Con.Close
Set Con = Nothing
%>
Avatar billede gnuffel Nybegynder
15. september 2003 - 19:42 #9
Eagle::
Microsoft VBScript runtime error '800a01a8'

Object required: ''

idx2.asp, line 126


Line 126 indeholder:
If Not (rs.BOF Or rs.EOF) Then
Avatar billede eagleeye Praktikant
15. september 2003 - 20:47 #10
arh for meget copy/paste det sakl være navnet på dit recordet sæt sådan her:


If Not (record.BOF Or record.EOF) Then
Avatar billede eagleeye Praktikant
15. september 2003 - 20:48 #11
Det samme gælder i denne linje:

  Do While Not rs.EOF And intRecCount > 0

Det skal være sådan her:

  Do While Not record.EOF And intRecCount > 0
Avatar billede eagleeye Praktikant
15. september 2003 - 20:50 #12
;) nu gik det for hurtigt igen det er alle disse linjer rs skal rettes til record:

If Not (rs.BOF Or rs.EOF) Then
  rs.PageSize = 10
  rs.AbsolutePage = intPage
  intRecCount = rs.PageSize
  intPageCount = rs.PageCount

  Do While Not rs.EOF And intRecCount > 0



sådan her:

If Not (record.BOF Or record.EOF) Then
  record.PageSize = 10
  record.AbsolutePage = intPage
  intRecCount = record.PageSize
  intPageCount = record.PageCount

  Do While Not record.EOF And intRecCount > 0
Avatar billede gnuffel Nybegynder
15. september 2003 - 22:28 #13
Jeg takker! det virker :D:D:D
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