Dela upp medlemslistan lite..

ASP

2 svar · 156 visningar · startad av Skywalker

Medlem sedan jan. 20012 437 inlägg
Trådstart#1

Nu behöver jag & www.motorforum.nu lite hjälp av er som har koll på det här miraklet ASP ;)

Jag vill dela upp ett recordset på flera sidor precis som det funkar här på wF, men jag begriper inte hur jag ska göra trots att jag läst Vide's FAQ 100 gånger ;)

Så här ser min kod ut i dag:

<html>
<head>
<title></title>
</head>
<body>
<%
Session("members") = "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("förbannat/hemligt.mdb")

Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open Session("members")
letter = Request("letter")
SQLStmt = "SELECT * FROM Members WHERE Members.M_Name LIKE '" & letter & "%' order by M_Name"
SET RS = Connection.Execute(SQLStmt)
%>
	<table border="0" cellspacing="0" cellpadding="5" width="100%" height="100%">
	<tr>
	<td align="center" valign="top" width="120">
<!--#INCLUDE FILE="left.asp" -->
	</td>
	<td align="left" valign="top">
<table border="0" width="90%" cellspacing="1" cellpadding="1">
	<tr>
	<td colspan="4" align="left" valign="top" width="30%">
<img src="logo.jpg">
	</td>
	</tr>
	<tr>
	<td colspan="4" align="center" valign="top" width="30%">
<font face="Verdana" Size="4" Color="#111111"><b>Medlemmar på Motorforum.nu:</b></font>
	</td>
	</tr>
	<tr>
	<td width="100%" colspan="4" align="center">
<a href="members.asp?letter=A">
<font face="Verdana" Size="2"><b>A</b></font></a>
<a href="members.asp?letter=B">
<font face="Verdana" Size="2"><b>B</b></font></a>
<a href="members.asp?letter=C">
<font face="Verdana" Size="2"><b>C</b></font></a>
<a href="members.asp?letter=D">
<font face="Verdana" Size="2""><b>D</b></font></a>
<a href="members.asp?letter=E">
<font face="Verdana" Size="2"><b>E</b></font></a>
<a href="members.asp?letter=F">
<font face="Verdana" Size="2"><b>F</b></font></a>
<a href="members.asp?letter=G">
<font face="Verdana" Size="2"><b>G</b></font></a>
<a href="members.asp?letter=H">
<font face="Verdana" Size="2"><b>H</b></font></a>
<a href="members.asp?letter=I">
<font face="Verdana" Size="2"><b>I</b></font></a>
<a href="members.asp?letter=J">
<font face="Verdana" Size="2"><b>J</b></font></a>
<a href="members.asp?letter=K">
<font face="Verdana" Size="2"><b>K</b></font></a>
<a href="members.asp?letter=L">
<font face="Verdana" Size="2"><b>L</b></font></a>
<a href="members.asp?letter=M">
<font face="Verdana" Size="2"><b>M</b></font></a>
<a href="members.asp?letter=N">
<font face="Verdana" Size="2"><b>N</b></font></a>
<a href="members.asp?letter=O">
<font face="Verdana" Size="2"><b>O</b></font></a>
<a href="members.asp?letter=P">
<font face="Verdana" Size="2"><b>P</b></font></a>
<a href="members.asp?letter=Q">
<font face="Verdana" Size="2"><b>Q</b></font></a>
<a href="members.asp?letter=R">
<font face="Verdana" Size="2"><b>R</b></font></a>
<a href="members.asp?letter=S">
<font face="Verdana" Size="2"><b>S</b></font></a>
<a href="members.asp?letter=T">
<font face="Verdana" Size="2"><b>T</b></font></a>
<a href="members.asp?letter=U">
<font face="Verdana" Size="2"><b>U</b></font></a>
<a href="members.asp?letter=V">
<font face="Verdana" Size="2"><b>V</b></font></a>
<a href="members.asp?letter=W">
<font face="Verdana" Size="2"><b>W</b></font></a>
<a href="members.asp?letter=X">
<font face="Verdana" Size="2"><b>X</b></font></a>
<a href="members.asp?letter=Y">
<font face="Verdana" Size="2"><b>Y</b></font></a>
<a href="members.asp?letter=Z">
<font face="Verdana" Size="2"><b>Z</b></font></a>
<a href="members.asp?letter=Å">
<font face="Verdana" Size="2"><b>Å</b></font></a>
<a href="members.asp?letter=Ä">
<font face="Verdana" Size="2"><b>Ä</b></font></a>
<a href="members.asp?letter=Ö">
<font face="Verdana" Size="2"><b>Ö</b></font></a>
	</td>
	</tr>
	<tr>
	<td align="left" valign="top" width="20%">
<font face="Verdana" Size="2" Color="#111111"><b>Namn:</b></font>
	</td>
	<td align="left" valign="top" width="30%">
<font face="Verdana" Size="2" Color="#111111"><b>E-post:</b></font>
	</td>
	<td align="center" valign="top" width="20%">
<font face="Verdana" Size="2" Color="#111111"><b>Inlägg:</b></font>
	</td>
	<td align="right" valign="top" width="30%">
<font face="Verdana" Size="2" Color="#111111"><b>Hemsida:</b></font>
	</td>
	</tr>
	<tr>
<% DO UNTIL RS.EOF %>
	<td align="left" valign="top" width="20%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#0033FF">&nbsp;<b><%= RS("M_Name") %></b></font>
	</td>
	<td align="left" valign="top" width="30%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#111111">&nbsp;<a href="mailto:<%= RS("M_Email") %>"><%= RS("M_Email") %></a></font>
	</td>
	<td align="center" valign="top" width="20%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#111111">&nbsp;<%= RS("M_Posts") %></font>
	</td>
	<td align="right" valign="top" width="30%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#111111">&nbsp;<a href="http://<%= RS("M_Homepage") %>" target="new"><%= RS("M_Homepage") %></a></font>
	</td>
	</tr>
	<tr>
<%
RS.MoveNext
Loop
%>
	</tr>
	<tr>
	<td width="100%" colspan="4" align="center">
<a href="members.asp?letter=A">
<font face="Verdana" Size="2"><b>A</b></font></a>
<a href="members.asp?letter=B">
<font face="Verdana" Size="2"><b>B</b></font></a>
<a href="members.asp?letter=C">
<font face="Verdana" Size="2"><b>C</b></font></a>
<a href="members.asp?letter=D">
<font face="Verdana" Size="2""><b>D</b></font></a>
<a href="members.asp?letter=E">
<font face="Verdana" Size="2"><b>E</b></font></a>
<a href="members.asp?letter=F">
<font face="Verdana" Size="2"><b>F</b></font></a>
<a href="members.asp?letter=G">
<font face="Verdana" Size="2"><b>G</b></font></a>
<a href="members.asp?letter=H">
<font face="Verdana" Size="2"><b>H</b></font></a>
<a href="members.asp?letter=I">
<font face="Verdana" Size="2"><b>I</b></font></a>
<a href="members.asp?letter=J">
<font face="Verdana" Size="2"><b>J</b></font></a>
<a href="members.asp?letter=K">
<font face="Verdana" Size="2"><b>K</b></font></a>
<a href="members.asp?letter=L">
<font face="Verdana" Size="2"><b>L</b></font></a>
<a href="members.asp?letter=M">
<font face="Verdana" Size="2"><b>M</b></font></a>
<a href="members.asp?letter=N">
<font face="Verdana" Size="2"><b>N</b></font></a>
<a href="members.asp?letter=O">
<font face="Verdana" Size="2"><b>O</b></font></a>
<a href="members.asp?letter=P">
<font face="Verdana" Size="2"><b>P</b></font></a>
<a href="members.asp?letter=Q">
<font face="Verdana" Size="2"><b>Q</b></font></a>
<a href="members.asp?letter=R">
<font face="Verdana" Size="2"><b>R</b></font></a>
<a href="members.asp?letter=S">
<font face="Verdana" Size="2"><b>S</b></font></a>
<a href="members.asp?letter=T">
<font face="Verdana" Size="2"><b>T</b></font></a>
<a href="members.asp?letter=U">
<font face="Verdana" Size="2"><b>U</b></font></a>
<a href="members.asp?letter=V">
<font face="Verdana" Size="2"><b>V</b></font></a>
<a href="members.asp?letter=W">
<font face="Verdana" Size="2"><b>W</b></font></a>
<a href="members.asp?letter=X">
<font face="Verdana" Size="2"><b>X</b></font></a>
<a href="members.asp?letter=Y">
<font face="Verdana" Size="2"><b>Y</b></font></a>
<a href="members.asp?letter=Z">
<font face="Verdana" Size="2"><b>Z</b></font></a>
<a href="members.asp?letter=Å">
<font face="Verdana" Size="2"><b>Å</b></font></a>
<a href="members.asp?letter=Ä">
<font face="Verdana" Size="2"><b>Ä</b></font></a>
<a href="members.asp?letter=Ö">
<font face="Verdana" Size="2"><b>Ö</b></font></a>
	</td>
	</tr>
	</table>
	</td>
	</tr>
	</table>

Här är sidan: www.motorforum.nu/members.asp

Jag vill alltså att det skall visas 20 medlemmar som default och sedan skall man kunna klicka på "Nästa 20" eller liknande.. Ni förstår nog :)

Medlem sedan aug. 2000864 inlägg
#2

Titta här http://cgi.webforum.nu/wf/arkiv/asp_faq.html#paging och sen byt ut där det står tio mot tjugo jag fick det att funka med lite modifiering på http://www.costodia.com/lund/Statistik/index-12.asp

Medlem sedan jan. 2000371 inlägg
#3

Om du vill så kan jag bygga en lite enklare kod åt dig, skicka ett mail om du intresserad.

278 ms totalt · 4 externa anrop · v20260731065814-full.d34c6d5a
123 ms — deklarationer (db)
0 ms — hämta statistik (cache)
144 ms — hämta tråd, inlägg och bilagor (db)
130 ms — ändringar (db)