Previous/Next records in asp

Nicky2k · January 24th, 2004, 03:30 AM

Please tell me how do do this, assuming the following
<%Option Explicit
dim objconn, objRS,strSQL

set objconn=server.createobject("adodb.connection")
objconn.open "DSN=PMS"

set objRS=server.createobject("adodb.recordset")

strSQL="SELECT * FROM Projects"
objRS.open, strSQL,3,3
%>

<html>
<head>
<title>Projects</title>
</head>
<body>
<table align="center" width="100%" height="100%">
<tr>
<td>Project Title</td>
</tr>
<tr>
<td>Project Status</td>
</tr>
<%while not objRS.recordcount%>
<tr>
<td><%=objRS("project_title")%></td>
</tr>
<tr>
<td><%=objRS("project_status")%></td>
</tr>
<%objRS.MoveNext
wend%>
</table>
</body>
</html>

Thanks.

Nicky.

Imar · January 24th, 2004, 04:57 AM

Hi there,

What you are looking for is call "paging" where the contents of a Recordset are split over multiple pages.
If you're using a tool like Dreamweaver MX, this is really easy. Just add a Server Behavior, set a few properties and off you go.

If you're hand coding, you may be interested in this article: http://www.asp101.com/samples/db_paging.asp

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Nicky2k · January 24th, 2004, 05:39 AM

Thanks. This is ecaxtlu what I was looking for.