<% Rem ********************************************************* Rem * Creating and opening a connection to the ICA database * Rem ... Set gcnCon = Server.CreateObject("ADODB.Connection") gcnCon.Open strConnexion Rem ... Rem * End opening the DB connection Rem ********************************************************* Rem **************************************************************** Rem * Creating the recordsets with ALL data Rem ... strQuery = "SELECT DISTINCTROW StudentProjects.* " strQuery = strQuery & "FROM (StudentProjects INNER JOIN StudentProjectXCategory ON StudentProjects.ProjectID = StudentProjectXCategory.ProjectID)" strQuery = strQuery & " INNER JOIN StudentProjectXLevel ON StudentProjects.ProjectID = StudentProjectXLevel.ProjectID WHERE Status = 'Proposal' AND LevelID = 1 ORDER BY Lab, Title" Set grsSemester = gcnCon.Execute(strQuery) strQuery1 = "SELECT DISTINCTROW StudentProjects.* " strQuery1 = strQuery1 & "FROM (StudentProjects INNER JOIN StudentProjectXCategory ON StudentProjects.ProjectID = StudentProjectXCategory.ProjectID)" strQuery1 = strQuery1 & " INNER JOIN StudentProjectXLevel ON StudentProjects.ProjectID = StudentProjectXLevel.ProjectID WHERE Status = 'Proposal' AND LevelID = 2 ORDER BY Lab, Title" Set grsDiploma = gcnCon.Execute(strQuery1) strQuery2 = "SELECT DISTINCTROW StudentProjects.* " strQuery2 = strQuery2 & "FROM (StudentProjects INNER JOIN StudentProjectXCategory ON StudentProjects.ProjectID = StudentProjectXCategory.ProjectID)" strQuery2 = strQuery2 & " INNER JOIN StudentProjectXLevel ON StudentProjects.ProjectID = StudentProjectXLevel.ProjectID WHERE Status = 'Proposal' AND LevelID = 3 ORDER BY Lab, Title" Set grsDSchool = gcnCon.Execute(strQuery2) Rem ... Rem * End creating recordsets Rem ********************************************************* %>
Welcome to the project offering of LCA.
Projects are intended in principle for students of the Communication Systems, Computer Science and Electrical Engineering Divisions. Most of these projects are focused on networking issues.
<% Rem ********************************************************* Rem * Find + display the Semester Projects Rem ... %>
Semester Projects <%grsSemester.MoveFirst%><% Rem ... Rem * End of Semester Projects List Rem **************************************************************** %> <% Rem **************************************************************** Rem * Creating the recordset with Diploma Projects, proposal Status Rem ... %>LCA1 : Prof. Jean-Pierre Hubaux 's Group
<%While (grsSemester.EOF <> TRUE) AND grsSemester("Lab") = "LCA1" strTitle = grsSemester("Title") strNum = Cstr(grsSemester("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsSemester.MoveNext wend %><% =strTitle%> LCA2 : Prof. Jean-Yves Le Boudec 's Group
<%While (grsSemester.EOF <> TRUE) AND grsSemester("Lab") = "LCA2" strTitle = grsSemester("Title") strNum = Cstr(grsSemester("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsSemester.MoveNext wend %><% =strTitle%> LCA3 : Prof. Patrick Thiran 's Group
<%While (grsSemester.EOF <> TRUE) AND grsSemester("Lab") = "LCA3" strTitle = grsSemester("Title") strNum = Cstr(grsSemester("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsSemester.MoveNext wend %><% =strTitle%> LCA4 : Prof. Matthias Grossglauser 's Group
<%While (grsSemester.EOF <> TRUE) strTitle = grsSemester("Title") strNum = Cstr(grsSemester("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsSemester.MoveNext wend %><% =strTitle%>
Master projects <%grsDiploma.MoveFirst%><% Rem Rem * End of Diploma Projects List Rem ******************************* %>LCA1 : Prof. Jean-Pierre Hubaux 's Group
<%While (grsDiploma.EOF <> TRUE) AND grsDiploma("Lab") = "LCA1" strTitle = grsDiploma("Title") strNum = Cstr(grsDiploma("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDiploma.MoveNext wend %><% =strTitle%> LCA2 : Prof. Jean-Yves Le Boudec 's Group
<%While (grsDiploma.EOF <> TRUE) AND grsDiploma("Lab") = "LCA2" strTitle = grsDiploma("Title") strNum = Cstr(grsDiploma("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDiploma.MoveNext wend %><% =strTitle%> LCA3 : Prof. Patrick Thiran 's Group
<%While (grsDiploma.EOF <> TRUE) AND grsDiploma("Lab") = "LCA3" strTitle = grsDiploma("Title") strNum = Cstr(grsDiploma("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDiploma.MoveNext wend %><% =strTitle%> LCA4 : Prof. Matthias Grossglauser 's Group
<%While (grsDiploma.EOF <> TRUE) strTitle = grsDiploma("Title") strNum = Cstr(grsDiploma("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDiploma.MoveNext wend %><% =strTitle%>
Doctoral School Projects <%grsDSchool.MoveFirst%>LCA1 : Prof. Jean-Pierre Hubaux 's Group
<%While (grsDSchool.EOF <> TRUE) AND grsDSchool("Lab") = "LCA1" strTitle = grsDSchool("Title") strNum = Cstr(grsDSchool("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDSchool.MoveNext wend %><% =strTitle%> LCA2 : Prof. Jean-Yves Le Boudec 's Group
<%While (grsDSchool.EOF <> TRUE) AND grsDSchool("Lab") = "LCA2" strTitle = grsDSchool("Title") strNum = Cstr(grsDSchool("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDSchool.MoveNext wend %><% =strTitle%> LCA3 : Prof. Patrick Thiran 's Group
<%While (grsDSchool.EOF <> TRUE) AND grsDSchool("Lab") = "LCA3" strTitle = grsDSchool("Title") strNum = Cstr(grsDSchool("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDSchool.MoveNext wend %><% =strTitle%> LCA4 : Prof. Matthias Grossglauser 's Group
<%While (grsDSchool.EOF <> TRUE) strTitle = grsDSchool("Title") strNum = Cstr(grsDSchool("ProjectID")) strLink = "student_project_display.asp?ProjectID=" & strNum %> <%grsDSchool.MoveNext wend %><% =strTitle%>
<% grsSemester.Close grsDiploma.Close grsDSchool.Close gcnCon.Close Set grsSemester = Nothing Set grsDiploma = Nothing Set grsDSchool = Nothing Set gcnCon = Nothing %>Search projects by keywords, level, domain, responsible...