webForumDet fria alternativet
Logga in / Bli medlem

Dela upp medlemslistan lite..

ASP

2 svar · 150 visningar · startad av Skywalker

SkywalkerMedlem sedan jan. 20012 437 inlägg
Frågan#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 :)

------------------
Kom till mig: www.motorforum.nu

costodiaMedlem 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

------------------
Mvh Martin Persson
www.Costodia.com

cgiMedlem 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.

263 ms totalt · 4 externa anrop · v20260731065814-full.86ec41c2
117 ms — deklarationer (db)
0 ms — hämta statistik (cache)
131 ms — hämta tråd, inlägg och bilagor (db)
128 ms — ändringar (db)