|
Dear Sirs,
I am Sumit Sharma, from India.
I am beginner in ASP.
I have made a asp file in which database is a MS access.
I have written the following script, But it was showing the all data which is in database file,
I want only 10 data, display one time, and next 10 data in another page and so on.
SCRIPT:
****************************************************************
<% Option Explicit %>
<html><head><title>The Cafeteria Menu</title></head>
<body bgcolor="Yellow">
<h1> The Cafeteria Menu </h1>
<%
Dim Connect, OnMenu
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Menu"
Set OnMenu = Connect.Execute(_
"SELECT * FROM Menu ORDER BY Date")
%>
<table border=1 width=100%
bordercolor=Red cellspacing=0 cellpadding=5>
<tr><th bgcolor="#99FFCC" align=left>Date</th>
<th bgcolor="#99FFCC" align=left>Main Course</th>
<th bgcolor="#99FFCC" align=left>Fruit</th>
<th bgcolor="#99FFCC" align=left>Vegetable</th>
<th bgcolor="#99FFCC" align=left>Desert</th>
</tr>
<%
Do while not onMenu.EOF %>
<tr><td><%=onMenu("Date")%></td>
<td><%=onMenu("Maincourse")%></td>
<td><%=onMenu("Fruit")%></td>
<td><%=onMenu("Vegetable")%></td>
<td><%=onMenu("Dessert")%></td></tr>
<% onMenu.MoveNext
loop %>
</table>
</body>
</html>
*************************************************************************
Please can body help me to complete this task for me.
I am waiting for your reply.
Thanking you, Sir.
Yours faithfully,
Sumit Sharma.
Web: http://www.sumitinfoway.tk - http://www.sumitinfoway.tk
http://www.sumitsharma.tk - http://www.sumitsharma.tk
|