<%
Rem *********************************************************
Rem * Creating and opening a connection to the LCA database *
Rem *********************************************************
Set gcnCon = Server.CreateObject("ADODB.Connection")
'gcnCon.Open "dsn=ICA_Database"
gcnCon.Open strConnexion
Rem ************************************************
Rem * Creating and filling up the recordset object *
Rem ************************************************
Set grsMembers = gcnCon.Execute("SELECT MembersID, FirstName, LastName FROM Members WHERE StillActive = TRUE ORDER BY LastName")
Set grsStudentProjectLevels = gcnCon.Execute("SELECT * FROM StudentProjectLevels ORDER BY LevelID")
Set grsStudentProjectCategories = gcnCon.Execute("SELECT * FROM StudentProjectCategories ORDER BY CategoryName")
%>
Please, specify a query to get a list of projects,
which fits best to your needs.
