<%@include file="includes/dbConnection.jsp"%> <%@page errorPage="error.jsp"%> NAAIIP
<% String type="%Spot%"; if(request.getParameter("type")!=null) { type=request.getParameter("type"); } %> <%@ include file="includes/Header.jsp"%>
 
<%//@ include file="includes/rsidemenu.jsp"%>

Spotlights

<% String QrySpceo="select * from resume_contact_info where company_id=2204 and subcategory like '" + type + "' order by resume_id DESC"; Statement stmtspceo=con1.createStatement(); // System.out.println("----------="+QrySpceo); ResultSet rsspceo=stmtspceo.executeQuery(QrySpceo); int countspc=0; while(rsspceo.next()) { //System.out.println(""); countspc++; String resume=rsspceo.getString("resume_id"); // String QrySpceo1="select description,type from MAIN_PROFILE where resume_id='"+resume+"'"; String sql="select MAIN_PROFILE.DESCRIPTION,MAIN_PROFILE.type,resume_data.photopath from MAIN_PROFILE inner join resume_data on MAIN_PROFILE.RESUME_ID=resume_data.resume_id where resume_data.resume_id='"+resume+"'"; Statement stmtspceo1=con1.createStatement(); // System.out.println("----------="+QrySpceo); ResultSet rsspceo1=stmtspceo1.executeQuery(sql); int cnt=0; while(rsspceo1.next()) { cnt++; %>
" width="100" height="100" align="left" style="margin-right:5px; background:#CCCCCC" alt="No Images Availabe"/>

<%=rsspceo.getString("firstname")%> <%=rsspceo.getString("lastname")%>


<%=rsspceo1.getString("type")%>
<%=rsspceo1.getString("description")%>


 

<% } } %>

<%@ include file="includes/rsidemenu.jsp"%>

<%@ include file="includes/Footer.jsp"%>