header("Search for Applications", project.HAppQueryImage, ""); client.resdep=request.resdep; client.ressite=request.ressite; client.restitle=request.restitle; client.reshrmgr=request.reshrmgr; if (project.applicationOptionsReusable!="true"){ dbConnect(); ComputeOptions("ressite", "application"); ComputeOptions("resdep", "application"); ComputeOptions("reshrmgr", "application"); ComputeOptions("restitle", "application"); project.applicationOptionsReusable="true"; dbDisconnect(); };
header2("", "Customize application listing:", button("KeyWord", null, "appbycontent.html"), button("Submit", null, "javascript:document.formQuery.submit()"), "", "");
LOCATION DEPARTMENT
TITLE HIRING MANAGER


fields = new FieldsList("APPLICATION"); dbConnect(); whereClause = ""; extendWhere("ressite"); extendWhere("resdep"); extendWhere("restitle"); extendWhere("reshrmgr"); if (whereClause!=""){whereClause=" WHERE " + whereClause}; cursor = database.cursor("SELECT resid, resjid, resreq, ressite, resdep, restitle, reshrmgr, resname FROM APPLICATION" + whereClause + ";"); foundData=false; write("" +"" +"
" +"" +"" +"" +"" +"" +"" +""); while (cursor.next()){ foundData=true; write("" + "" + "" + "" + "" + "" + ""); }; write("" +"
DEPT. and
" +"LOCATION
HIRING MGR.REQ NUM and
" +"JOB TITLE
APPLICANT
" + fetchV("resdep") + "
" +"" + fetchV("ressite") + "
" + fetchV("reshrmgr") + "" + fetchV("resreq") + "
" + "" + fetchV("restitle") + "
" + "" + fetchV("resname") + "
" +"
"); if (foundData!=true){write("
Sorry, no applications were found that match your request.

") }; dbDisconnect(); footer();