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
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"> <b><%= RS("M_Name") %></b></font>
</td>
<td align="left" valign="top" width="30%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#111111"> <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"> <%= RS("M_Posts") %></font>
</td>
<td align="right" valign="top" width="30%" bgcolor="#f1f1f1">
<font face="Verdana" Size="1" Color="#111111"> <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