<%@LANGUAGE="JAVASCRIPT"%> <% // first grab the path to the script (e.g. /dev/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 status = fileArr[0]; category = URLArray[directoryIdx]; // var news_inc_type = "social"; // var news_inc_type = "employment"; // var news_inc_type = "environment"; var news_inc_type = "generic"; var breadcrumb = ""; var page_title = ""; if (category == "employment") { if (status == "recent") { breadcrumb = "Employment Completed Projects"; page_title = "Employment: Completed Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Employment group' AND r.completed = 'Yes' ORDER BY project_name ASC"; } else if (status == "current") { breadcrumb = "Employment Current Projects"; page_title = "Employment: Current Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Employment group' AND r.completed = 'No' ORDER BY project_name ASC"; } else { breadcrumb = "Employment All Projects"; page_title = "Employment: All Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Employment group' ORDER BY project_name ASC"; } } else if (category == "environment") { if (status == "recent") { breadcrumb = "Environment Completed Projects"; page_title = "Environment: Completed Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Environment group' AND r.completed = 'Yes' ORDER BY project_name ASC"; } else if (status == "current") { breadcrumb = "Environment Current Projects"; page_title = "Environment: Current Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Environment group' AND r.completed = 'No' ORDER BY project_name ASC"; } else { breadcrumb = "Environment All Projects"; page_title = "Environment: All Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Environment group' ORDER BY project_name ASC"; } } else if (category == "social") { if (status == "recent") { breadcrumb = "Social Completed Projects"; page_title = "Social: Completed Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Social Policy group' AND r.completed = 'Yes' ORDER BY project_name ASC"; } else if (status == "current") { breadcrumb = "Social Current Projects"; page_title = "Social: Current Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Social Policy group' AND r.completed = 'No' ORDER BY project_name ASC"; } else { breadcrumb = "Social All Projects"; page_title = "Social: All Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND rc.research_category_name = 'Social Policy group' ORDER BY project_name ASC"; } } else if (category == "wasp") { if (status == "recent") { breadcrumb = "Work and Social Policy Completed Projects"; page_title = "Work and Social Policy: Completed Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND (rc.research_category_name = 'Social Policy group' OR rc.research_category_name = 'Employment group') AND r.completed = 'Yes' ORDER BY project_name ASC"; } else if (status == "current") { breadcrumb = "Work and Social Policy Current Projects"; page_title = "Work and Social Policy: Current Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND (rc.research_category_name = 'Social Policy group' OR rc.research_category_name = 'Employment group') AND r.completed = 'No' ORDER BY project_name ASC"; } else { breadcrumb = "Work and Social Policy All Projects"; page_title = "Work and Social Policy: All Projects"; sql_query = "SELECT * FROM Research_Project r, Research_Project_Category rpc, Research_Category rc WHERE r.project_id = rpc.project_id AND rpc.category_id = rc.category_id AND (rc.research_category_name = 'Social Policy group' OR rc.research_category_name = 'Employment group') ORDER BY project_name ASC"; } } else { if (status == "recent") { breadcrumb = "Completed Projects"; page_title = "Completed Projects"; sql_query = "SELECT * FROM Research_Project WHERE completed = 'Yes' ORDER BY project_name ASC"; } else if (status == "current") { breadcrumb = "Current Projects"; page_title = "Current Projects"; sql_query = "SELECT * FROM Research_Project WHERE completed = 'No' ORDER BY project_name ASC"; } else { breadcrumb = "All Projects"; page_title = "All Projects"; sql_query = "SELECT * FROM Research_Project ORDER BY project_name ASC"; } } var projects = Server.CreateObject("ADODB.Recordset"); projects.ActiveConnection = MM_psi_db_STRING; projects.Source = sql_query; projects.CursorType = 0; projects.CursorLocation = 2; projects.LockType = 3; projects.Open(); var projects_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; projects_numRows += Repeat1__numRows; %> PSI: Research: <%=(page_title)%>
<% var colour_count = 3; var bg_colour_code = "#F7F7EE"; %> <% while ((Repeat1__numRows-- != 0) && (!projects.EOF)) { %> > <% Repeat1__index++; projects.MoveNext(); } %>

Title

Sponsor

Project Leader

     

"><%=(projects.Fields.Item("project_name").Value)%>

<%=(projects.Fields.Item("sponsors").Value)%>

<% var leader = Server.CreateObject("ADODB.Recordset"); leader.ActiveConnection = MM_psi_db_STRING; leader.Source = "SELECT * FROM Person WHERE person_id = " + projects.Fields.Item("project_leader_id").Value; leader.CursorType = 0; leader.CursorLocation = 2; leader.LockType = 3; leader.Open(); %> <% if (!leader.EOF && !leader.BOF) { %> "><%=(leader.Fields.Item("first_name").Value)%> <%=(leader.Fields.Item("last_name").Value)%> <% } else { %> <% } %> <% leader.Close(); %>

Return to the top of this page

<% projects.Close(); %>