Page 314 - DCAP408_WEB_PROGRAMMING

Web Programming

Notes 10. <B>Entries in table</B>
11. <P>
12. <Table>
13. <TR>
14. <TD>Name</TD>
15. <TD>Email</TD>
16. <TD>Username</TD>
17. </TR>

18. <% Do While Not objRS.EQF %>
19. <TR>
20. <TD><%=objRS(“LastName”) %>, <%=objRS(“Firstname”) %></TD>
21. <TD><%=objRS(“Email”) %></TD>
22. <%=objRS(“Username”) %></TD>
23. </TR>
24. <% objRS.MoveNext

25. Loop
26. objRS.MoveFirst
27. objRS.Delete
28. objRS.MoveFirst %>
29. </TABLE>
30. <P>
31. <TABLE>
32. <% Do While Not objRS.EQF %>
33. <TR>

34. <TD><%=objRS(“LastName”) %>, <%=objRS(“Firstname”) %></TD>
35. <TD><%=objRS(“Email”) %></TD>
36. <%=objRS(“Username”) %></TD>
37. </TR>
38. <% objRS.MoveNext
39. Loop
40. objRS.Close

41. Set objRS = Nothing
42. objConn.close
43. Set objConn = Nothing
44. %>
45. </Table>
46. </BODY>
47. </HTML>

308 LOVELY PROFESSIONAL UNIVERSITY