%@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;
%>