<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@include file="/field_manager/include/manager_head.jsp"%> <% String c_home = r_call(request.getParameter("c_home")); String c_project_no = r_call(request.getParameter("c_project_no")); if(c_project_no.equals("")){ %> <% }else{ String sql_up = " SELECT c.*, a.c_name as u_name, b.c_name as f_name "; sql_up = sql_up + " , (select c_now_propose from tbl_project_plan where c_relation = 0 and c_project_no = c.c_no) as c_now_propose " ; sql_up = sql_up + " from tbl_project c "; sql_up = sql_up + " inner join tbl_project a on a.c_no = c.c_up_no "; sql_up = sql_up + " inner join tbl_field b on b.c_no = a.c_field "; sql_up = sql_up + " where c.c_no = " + c_project_no; ResultSet rs_up = stmt.executeQuery(sql_up); if (rs_up.next()) { %>

설문프로젝트 등록 메인필드 <%=rs_up.getString("f_name")%> Category <%=rs_up.getString("u_name")%> Project명 <%=rs_up.getString("c_name")%> <% } rs_up.close(); } %> * 표시가 있는 항목은 반드시 입력해 주세요. *설문프로젝트 명 *시용설문 <% String sql1=" SELECT * from tbl_survey where c_home = " + c_home + " and c_maker = 0 and c_use=0 order by c_no desc"; ResultSet rst = stmt.executeQuery(sql1); while (rst.next()){%> "><%=rst.getString("c_name")%> <%} rst.close(); %> * 필요 설문이 없을 경우 설문관리를 먼저 해 주세요. *설문 안내내용 등록 취소

<%@include file="/field_manager/include/manager_bottom.jsp"%>