<%@ Language=VBScript %> COEN120 Student Group-Project Groups <% Set DB = Server.CreateObject("ADODB.connection") DB.Open "COEN120StudentsWinter2003", "COEN120Students", "COEN120Students" %>
COEN120 Student Group-Project Groups

<% GroupCounter = 0 SearchString = "SELECT * FROM q_Groups ORDER BY GroupNum" ' response.write SearchString & "
" Set Group_Results = DB.Execute(SearchString) while not Group_Results.eof %> <% while (GroupCounter <> Group_Results("GroupNum")) GroupCounter = GroupCounter + 1 %> <% wend %> <% Group_Results.MoveNext wend %>

First Name

Last Name

Lab

E-Mail

Picture

Group <% =GroupCounter %>

<%=Group_Results("FirstName")%>

<%=Group_Results("LastName")%>

<%=Group_Results("Lab")%>

"><%=Group_Results("email")%>

.jpg">