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,"<","<") besked = Replace(besked,">",">") %> <% 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 %>
Annonceindlæg fra QNAP
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,"<","<") besked = Replace(besked,">",">") %> <% 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 %>
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
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,"<","<") besked = Replace(besked,">",">") %> <b><font face="verdana" size="1" color="black">Skrevet af </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> | <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")%> klokken <% 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"> </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!
15. september 2003 - 18:58
#4
Jeg kan godt men det er ikke noget jeg vil gøre for point - sorry
15. september 2003 - 19:14
#5
k
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!
15. september 2003 - 19:16
#7
Jeg vil gerne give et bud på koden hvis du har lyst?
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,"<","<") besked = Replace(besked,">",">") %> <b><font face="verdana" size="1" color="black">Skrevet af </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> | <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")%> klokken <% 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"> </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 & "><<</a>" Else Response.Write "<<" End If Response.Write " " If Clng(intPage) < Clng(intPageCount) Then Response.Write "<a href=?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" 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 %>
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
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
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
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
15. september 2003 - 22:28
#13
Jeg takker! det virker :D:D:D
Kurser inden for grundlæggende programmering