<%@LANGUAGE="JAVASCRIPT"%> <% // first grab the path to the script (e.g. /research/employment/current.asp) URLPath = new String(Request.ServerVariables('SCRIPT_NAME')); // split it into an array, based on / URLArray = URLPath.split("/"); // the filename is the last element in the array, and the dir is the last but one filenameIdx = URLArray.length - 1; directoryIdx = URLArray.length - 2; // be lazy and don't learn any more JScript functions, // so split on the . in the filename (rather than strip off the end .asp) fileArr = URLArray[filenameIdx].split("."); // grab the filename (not extension) for the status var filename = fileArr[0]; directory = URLArray[directoryIdx]; if (filename == "seminars") { sql_query = "SELECT * FROM Event e, Event_Category ec WHERE e.event_category_id = ec.event_category_id AND ec.event_category_name = 'Seminars' ORDER BY event_start DESC"; breadcrumb_title = "Seminars"; } else if (filename == "workshops") { sql_query = "SELECT * FROM Event e, Event_Category ec WHERE e.event_category_id = ec.event_category_id AND ec.event_category_name = 'Workshops' ORDER BY event_start DESC"; breadcrumb_title = "Workshops"; } else if (filename == "conferences") { sql_query = "SELECT * FROM Event e, Event_Category ec WHERE e.event_category_id = ec.event_category_id AND ec.event_category_name = 'Conferences' ORDER BY event_start DESC"; breadcrumb_title = "Conferences"; } else if (filename == "psi-wbs_seminars") { sql_query = "SELECT * FROM Event e, Event_Category ec WHERE e.event_category_id = ec.event_category_id AND ec.event_category_name = 'PSI-WBS_Seminars' ORDER BY event_start DESC"; breadcrumb_title = "PSI-WBS Seminars"; } else { sql_query = "SELECT * FROM Event ORDER BY event_start DESC"; breadcrumb_title = "All Events"; } var event = Server.CreateObject("ADODB.Recordset"); event.ActiveConnection = MM_psi_db_STRING; event.Source = sql_query; event.CursorType = 0; event.CursorLocation = 2; event.LockType = 3; event.Open(); var event_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; event_numRows += Repeat1__numRows; %> PSI: Events: <%=(breadcrumb_title)%>

<% if (style != "default") { %> breadcrumb links: <% } else { %> <% } %>PSI > Events > <%=(breadcrumb_title)%>
<% var colour_count = 3; var bg_colour_code = "#FFF7E6"; %> <% while ((Repeat1__numRows-- != 0) && (!event.EOF)) { %> > <% Repeat1__index++; event.MoveNext(); } %>

Date

Speaker

Event
 

<% var event_start = new Date(event.Fields.Item("event_start").Value); if (event_start != null) { var disp_date = event_start.getDate() + "/" ; disp_date += event_start.getMonth() +1 + "/" ; disp_date += event_start.getYear(); } %><%=(disp_date)%>

<%=(event.Fields.Item("event_speaker").Value)%> <% var speaker_institution = event.Fields.Item("speaker_institution").Value; if (speaker_institution != null) { %> (<%=speaker_institution%>) <% } %>

"><% var event_title = event.Fields.Item("event_title").Value; if (event_title != null) { %><%=(event_title)%><% } else { %>More information on this event<% } %>

Return to the top of this page
<% event.Close(); %>