<%-- advPlanSearch.jsp ----------------- A complete search form for Complete Plans and Plan Excerpts in the OERL relational database. Submitted to doPlanSearch.jsp. Javscript Includes: focusWindow.js Dynamic Includes: uncheck.js inc_errorTblHdrBGColor.html inc_tblHdrBGColor.html inc_tblIndentWidth.html inc_searchIntro.html inc_buttonsForm.html dinc_searchTitle.jsp Static Includes: sinc_checkEmptyProjectParams.jsp sinc_emptyFieldMessage.jsp sinc_formVars.jsp sinc_oerlWebViewCon.jsp sinc_printEmptyProjectFields.jsp (forms) sinc_componentForm.jsp sinc_contentAreaForm.jsp sinc_fundingSourceForm.jsp sinc_organizationForm.jsp sinc_projectTypeForm.jsp Created by zaz@sri.com. Last modified by zaz@sri.com, 3/10/03. --%> <%@ page errorPage="error.jsp" %> <%@ page import="java.sql.*" %> <% final String shortName = "plan"; final String longName = "Plan"; %> <%@ include file="codefragments/sinc_formVars.jsp" %> <%-- Make connection to database using oerl_webview login --%> <%@ include file="../jspcode/sinc_oerlWebViewCon.jsp" %> <% boolean hasEmptyFields = false, hasEmptyPlanType = false, hasEmptyComponent = false; // Check to see if there are any unspecified search parameters // described in the HTTP request parameters if (request.getParameter("hasEmptyFields") != null) hasEmptyFields = true; if (request.getParameter("hasEmptyPlanType") != null) hasEmptyPlanType = true; if (request.getParameter("hasEmptyComponent") != null) hasEmptyComponent = true; // Check for empty project field parameters %><%@ include file="codefragments/sinc_checkEmptyProjectParams.jsp" %> OERL: Plans: Search
home
  : Plans : Search





























home reports instruments plans
search

<% // If there are empty parameters, print a message to that effect if (hasEmptyFields) { %> <% if (hasEmptyPlanType) { %> <% } %> <% if (hasEmptyComponent) { %> <% } %> <%@ include file="codefragments/sinc_printEmptyProjectFields.jsp" %> <% } %> <% String listAllQuery = "?ListAll=true"; listAllQuery += "&noProjectTypeField=true"; listAllQuery += "&noFundingSourceField=true"; listAllQuery += "&noContentAreaField=true"; listAllQuery += "&noOrganizationField=true"; listAllQuery += "&noComponentField=true"; listAllQuery += "&noPlanTypeField=true"; %>

Overwhelmed by all the choices? You can go back to the simple search for plans. You can also view a list of all plans.

> <% } else { %> > <% } %> > <% } else { %> > <% } %> > <% } else { %> > <% } %> > <% } else { %> > <% } %> > <% } else { %> > <% } %> > <% } else { %> > <% } %>
For these Types of Plans:
> <% boolean doExcerpts = false, doComplete = false; values = request.getParameterValues("PlanType"); if (values != null) for (int i = 0; i < values.length; i++) if (values[i] != null) { if (values[i].equals("Excerpt")) doExcerpts = true; else if (values[i].equals("Complete")) doComplete = true; } String searchParam = request.getParameter("Search"); %>
checked<% } %>> Complete Plans checked<% } %>> Plan Excerpts
With these Components:
<% final String excerptType = "Plan Excerpt"; %> <%@ include file="forms/sinc_componentForm.jsp" %>
From these Types of Projects:
<% boolean doSubmitToURL = false; %> <%@ include file="forms/sinc_projectTypeForm.jsp" %>
From Projects funded by:
<%@ include file="forms/sinc_fundingSourceForm.jsp" %>
From Projects in these Content Areas:
<%@ include file="forms/sinc_contentAreaForm.jsp" %>
From Projects contributed by these Organizations:
<%@ include file="forms/sinc_organizationForm.jsp" %>
<% con.close(); %>