%@LANGUAGE="VBSCRIPT"%>
<%
Dim MM_connCRITO_STRING
MM_connCRITO_STRING = "dsn=CRITO;uid=crito.admin;pwd=cr1tonebula;"
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_connCRITO_STRING
Recordset1.Source = "SELECT ID, title, author1, dyear, url, research_area FROM dbo.papers WHERE research_area = 'MIS03' ORDER BY dyear DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
CRITO | Center for Research on Information Technology & Organizations
|
|
|
|
|
|
|
project
| papers
|
PROJECT PAPERS
|
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
|
<%=(Recordset1.Fields.Item("dyear").Value)%> |
|
<%=(Recordset1.Fields.Item("title").Value)%> (<%=(Recordset1.Fields.Item("url").Value)%>) by <%=(Recordset1.Fields.Item("author1").Value)%> |
|
 |
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
|
|
| | |
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>