Limit DB results on page 1

[rufc]

Hi,

I have made a simple forum for our intranet. Can anyone help me as the list of posts is getting quite long and I would like to limit the results to say 10 per page (and have Page 1 2 3 4 > links at the bottom).

Ho do I go about this? Here is how I gain the results from the DB

<% while not RS.EOF and not RS.BOF %>
<tr height='25'>
<td bgcolor='#EFEFEF'> <a href="/Forum/Message/index.asp?id=<%=RS("id")%>"><%=RS("title")%></a></td>
<td align="center" bgcolor='#EFEFEF'><%=RS("date_created")%></td>
</tr>
<%RS.movenext
 wend %>

Thanks in advance

 

[gavrooke]

you need to use a technique called paging, search for that in google, there are lots of examples

 

[rufc]

Thanks, I`ll have a look around the web for paging examples