Print Page | Close Window

How To View Data Separate

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=26268
Printed Date: 29 March 2026 at 4:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: How To View Data Separate
Posted By: sky
Subject: How To View Data Separate
Date Posted: 17 September 2008 at 11:24pm
Hi there..i need some help
 
this is the code:
 
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("users.mdb")
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT  USERNAME, TOPIC FROM usercomment"
rs.Open sql, conn
%>
</div>
<table width="50%" border="1" align="center" bgcolor="#CCCCCC">
  <tr>
  <%for each x in rs.Fields
     response.write("<th align='center' bgcolor='#b0c4de'>" & x.name & "</th>")
  next%>
  </tr>
  <%do until rs.EOF%>
    <tr>
    <%for each x in rs.Fields%>
      <td><%Response.Write(x.value)%></td>
    <%next
    rs.MoveNext%>
    </tr>
  <%loop
  rs.close
  conn.close%>
</table>
</body>
</html>
 
This code will bring the result where all the data show in one table..i want the data show one by one but still in the same page and how to set the data so that the data only show 10 records in one page..
Please somebody help me...
 


-------------
sky886


Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net