<%@ Language=VBScript %> COEN194-5-6 Projects and Meeting Times <% Set DB = Server.CreateObject("ADODB.connection") DB.Open "COEN194-5-6Students2003" SearchString = "SELECT * FROM q_AllStudentData ORDER BY MeetingBeginTime,LastName" ' response.write SearchString & "
" Set DB_Results = DB.Execute(SearchString) %>
COEN194-5-6 Projects and Meeting Times
<% while not DB_Results.eof %> <% DB_Results.MoveNext wend %>

First Name

Last Name

Project

Meeting Times

Location

<%=DB_Results("FirstName")%>

<%=DB_Results("LastName")%>

<%=DB_Results("Project")%>

<%=DB_Results("MeetingDay")%> <%=DB_Results("MeetingBeginTime")%> - <%=DB_Results("MeetingEndTime")%>

<%=DB_Results("Location")%>