<%
if (strOrder.equals("All")) {
strQryOrd = "WHERE mem_status = 'A'";
} else if (strOrder.equals("AC")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'A%' OR UPPER(company_name) LIKE 'B%' OR UPPER(company_name) LIKE 'C%') AND mem_status = 'A'";
} else if (strOrder.equals("DF")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'D%' OR UPPER(company_name) LIKE 'E%' OR UPPER(company_name) LIKE 'F%') AND mem_status = 'A'";
} else if (strOrder.equals("GI")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'G%' OR UPPER(company_name) LIKE 'H%' OR UPPER(company_name) LIKE 'I%') AND mem_status = 'A'";
} else if (strOrder.equals("JL")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'J%' OR UPPER(company_name) LIKE 'K%' OR UPPER(company_name) LIKE 'L%') AND mem_status = 'A'";
} else if (strOrder.equals("MO")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'M%' OR UPPER(company_name) LIKE 'N%' OR UPPER(company_name) LIKE 'O%') AND mem_status = 'A'";
} else if (strOrder.equals("PR")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'P%' OR UPPER(company_name) LIKE 'Q%' OR UPPER(company_name) LIKE 'R%') AND mem_status = 'A'";
} else if (strOrder.equals("SU")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'S%' OR UPPER(company_name) LIKE 'T%' OR UPPER(company_name) LIKE 'U%') AND mem_status = 'A'";
} else if (strOrder.equals("VX")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'V%' OR UPPER(company_name) LIKE 'W%' OR UPPER(company_name) LIKE 'X%') AND mem_status = 'A'";
} else if (strOrder.equals("YZ")) {
strQryOrd = "WHERE (UPPER(company_name) LIKE 'Y%' OR UPPER(company_name) LIKE 'Z%') AND mem_status = 'A'";
}
try {
if ( (strIndustSev.equals("none")) && (strTechFocus.equals("none")) && (strServiceOf.equals("none")) )
{
strQuery = "SELECT company_id, company_name FROM company_details "+strQryOrd+" ORDER BY Upper(company_name) ";
} else {
strQuery = "SELECT DISTINCT CD.company_id, company_name "+
"FROM company_details CD, company_skill_details CSD "+
"WHERE mem_status = 'A' "+
"AND CSD.skill_id = "+strSelCrit+" "+
"AND CD.company_id = CSD.company_id "+
"ORDER BY Upper(company_name) ";
}
stmt = conn.createStatement();
results = stmt.executeQuery(strQuery);
while (results.next()) {
strCompId = results.getString("company_id");
%>
|
<%=results.getString("company_name")%> |
|
<%
bFound = true;
} // end while
if (bFound == false) {
%>
|
Members not available. |
<%
}
} catch(SQLException e) {
try{
conn.close();
conn = null;
}catch(SQLException ex){
System.out.println("Cannot close logical connection");
}
} // catch
%>
|
|
Industry Served
|
|
Service Offered
|
|
Technology Focused
|
|
