Avatar billede morpheus Nybegynder
07. januar 2000 - 10:06 Der er 5 kommentarer og
3 løsninger

Bladrer funktion....!?

Hej !

Jeg søger en funktion til at bladre med...

Jeg har en side hvor der fx. bliver listet 30 records.

Her vil jeg kun have 5 listet, og i bunden af siden skal der være en bar hvor man kan vælge hvilken side man vil til, eller en knap hvor der står frem/tilbage !

Hvordan gør jeg det nemmest ?

SOURCE:
-------
<%
  Set Rs = Server.CreateObject("ADODB.Connection")
  DBPath = "DBQ=" & server.mappath("icq.mdb")
  Rs.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
%>
<html>
<head>
<title>ICQ Liste ver.: 1.0</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
A:link { font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
A:visited { text-decoration: underline;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:active { text-decoration: none;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:hover { font-size: 10pt; color: #306898;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
.text {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt}
.textstor {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16pt}
-->
</style></head>

<body bgcolor="#FFFFFF">
<div align='center' class='textstor'>
ICQ Svendborg ver. 1.0
</div>
<hr width='50%' align='center' noshade size='1'>
<%
SQL = "SELECT * FROM members ORDER by ID DESC"
SET rs = Rs.Execute(SQL)

if rs.eof then
  response.write "Der er ikke nogen medlemmer"
else

Do While Not rs.EOF
    response.write "<table width='50%' align='center' border='0'>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Bruger oprettet:</td>"
    response.write "<td class='text' width='30%' align='right'>" & FormatDateTime(rs("dato"), VbLongDate) & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Navn:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("realname") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Alder:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("alder") & "&nbsp;år</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Nickname:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("nick") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>ICQ #:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("icqnummer") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Online / Offline:</td>"
    response.write "<td class='text' width='30%' align='right'><img src='http://online.mirabilis.com/scripts/online.dll?icq=" & rs("icqnummer") & "&amp;img=5'></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Hjemmeside:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href=http://" & rs("url") & ">" & rs("titel") & "</a>]</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>E-Mail:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href='mailto:" & rs("email") & "'>" & rs("email") & "</a>]</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Mere information:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href='more.asp?id=" & rs("ID") & "'>Mere info</a>]</td>"
    response.write "</tr>"
    response.write "</table>"
    response.write "<hr width='50%' align='center' noshade size='1'>"

rs.MoveNext
loop
end if
%>
<br>
<br>
<div align='center' class='text'>
[<a href='tilmeld.asp'>Tilmeld dig listen</a>]
</div>
-----

Hjælp mig lige med at sætte det ind...
Avatar billede fætterguf Nybegynder
07. januar 2000 - 10:09 #1
<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 LinkURL FROM Links"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("/aspdigital/db/demo.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("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 & ">&lt;&lt;</a>"
Else
  Response.Write "&lt;&lt;"
End If

Response.Write "&nbsp;"

If Clng(intPage) < Clng(intPageCount) Then
  Response.Write "<a href=paging.asp?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
  Response.Write "&gt;&gt;"
End If
%>

</body></html>
Avatar billede morpheus Nybegynder
07. januar 2000 - 11:22 #2
Help....

Min source ser således ud:

SOURCE:
-------
<%
  Set Rs = Server.CreateObject("ADODB.Connection")
  DBPath = "DBQ=" & server.mappath("icq.mdb")
  Rs.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
%>
<html>
<head>
<title>ICQ Liste ver.: 1.0</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
A:link { font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
A:visited { text-decoration: underline;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:active { text-decoration: none;font-size: 10pt; color: #000000;; font-family: Verdana, Arial, Helvetica, sans-serif}
A:hover { font-size: 10pt; color: #306898;; font-family: Verdana, Arial, Helvetica, sans-serif; text-decoration: underline}
.text {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt}
.textstor {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16pt}
-->
</style></head>

<body bgcolor="#FFFFFF">

<%
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
  intPage = 1
End If
%>

<div align='center' class='textstor'>
ICQ Svendborg ver. 1.0
</div>
<hr width='50%' align='center' noshade size='1'>
<%
SQL = "SELECT * FROM members ORDER by ID DESC"
SET rs = Rs.Execute(SQL)

if rs.eof then
  response.write "Der er ikke nogen medlemmer"
else

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 "<table width='50%' align='center' border='0'>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Bruger oprettet:</td>"
    response.write "<td class='text' width='30%' align='right'>" & FormatDateTime(rs("dato"), VbLongDate) & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Navn:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("realname") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Alder:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("alder") & "&nbsp;år</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Nickname:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("nick") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>ICQ #:</td>"
    response.write "<td class='text' width='30%' align='right'>" & rs("icqnummer") & "</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Online / Offline:</td>"
    response.write "<td class='text' width='30%' align='right'><img src='http://online.mirabilis.com/scripts/online.dll?icq=" & rs("icqnummer") & "&amp;img=5'></td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Hjemmeside:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href=http://" & rs("url") & ">" & rs("titel") & "</a>]</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>E-Mail:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href='mailto:" & rs("email") & "'>" & rs("email") & "</a>]</td>"
    response.write "</tr>"
    response.write "<tr>"
    response.write "<td class='text' width='20%'>Mere information:</td>"
    response.write "<td class='text' width='30%' align='right'>[<a href='more.asp?id=" & rs("ID") & "'>Mere info</a>]</td>"
    response.write "</tr>"
    response.write "</table>"
    response.write "<hr width='50%' align='center' noshade size='1'>"



  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=default.asp?page=" & intNum & ">" & intNum & "</a> "
Next

Response.Write "<p>"
If Clng(intPage) > 1 Then
  Response.Write "<a href=paging.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=paging.asp?page=" & intPage + 1 & ">&gt;&gt;</a> "
Else
  Response.Write "&gt;&gt;"
End If
End If
%>

<br>
<br>
<div align='center' class='text'>
[<a href='tilmeld.asp'>Tilmeld dig listen</a>]
</div>
</body>
</html>

Jeg får følgende fejlmeddelse:

ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

/icq/Default.asp, line 44

Linie 44:
rs.AbsolutePage = intPage

Help !?!?!

<//morpheus\\>
Avatar billede skjoldby Nybegynder
07. januar 2000 - 13:07 #3
Linje 4 (Rs.Open) ændre du til således:
myDNS = "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath

Prøv at flytter du Rs.Open ned under din SQL variabel og ændre den således:

SQL = "SELECT * FROM members ORDER by ID DESC"
Rs.Open SQL, myDNS, 1


skjoldet.dk
Avatar billede morpheus Nybegynder
07. januar 2000 - 13:45 #4
Skjoldby>>>>
Din løsning giver følgende fejlmeddelse:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name too long

/icq/Default.asp, line 46

Linie 46:
Rs.Open SQL, myDNS, 1

<//morpheus\\>
Avatar billede skjoldby Nybegynder
07. januar 2000 - 16:15 #5
prøv at lave din rs sådan:
Set Rs = Server.CreateObject("ADODB.RecordSet")

og din myDSN sådan:
myDSN = "DRIVER={Microsoft Access Driver(*.mdb)};DBQ="&Server.MapPath("icq.mdb")
Avatar billede morpheus Nybegynder
07. januar 2000 - 20:17 #6
Følgende fejl opstod:
ADODB.Recordset fejl '800a0bb9'

Programmet benytter argumenter, som er af en forkert type, er uden for det acceptable område eller er i indbyrdes konflikt.

/icq/Default.asp, linje 47
Avatar billede KLS Novice
20. januar 2000 - 02:12 #7
Rs.Open SQL, myDNS, 1, 1

Dette burde hjælpe !
Avatar billede morpheus Nybegynder
20. januar 2000 - 08:28 #8
Har fået det til at virke...

Uden nogen af de kommentarer i havde.

Men derfor får i alle alligevel lidt point for jeres tid ! :o)

Tak for hjælpen

<//morpheus\\>
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