<%@ Language=VBScript %> COEN120 Student Roster <% Set DB = Server.CreateObject("ADODB.connection") DB.Open "COEN120StudentsSpring2002", "ENGR019Students", "ENGR019Students" SearchString = "SELECT * FROM q_AllStudentData ORDER BY LogName" ' response.write SearchString & "
" Set DB_Results = DB.Execute(SearchString) %>
COEN120 Student Roster
<% while not DB_Results.eof %> <% DB_Results.MoveNext wend %>

LogName

First Name

Last Name

E-Mail

Lab Section

Final Section

<%=DB_Results("LogName")%>

<%=DB_Results("FirstName")%>

<%=DB_Results("LastName")%>

<%=DB_Results("email")%>

<%=DB_Results("Lab")%>

<%=DB_Results("Final")%>