header("Applications selected by key words", project.HAppQueryImage, ""); //### needs own image### fields = new FieldsList("APPLICATION"); dbConnect(); whereClause = ""; extendWhereKW("jobtitle", 4, false); extendWhereKW("employer", 4, false); extendWhereKW("duties", 4, true); extendWhereKW("degree", 4, false); extendWhereKW("school", 4, false); extendWhereKW("major", 4, false); if (whereClause!=""){whereClause=" WHERE " + whereClause}; command="SELECT resid, resjid, resreq, ressite, resdep, restitle, reshrmgr, resname FROM APPLICATION" + whereClause; // // write("
QUERY="+command);flush(); // cursor = database.cursor(command); 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();