<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%
int c_project_no = 0;
int c_point_project_no = 0;
String sql_p = "select a.*, b.c_name as p_name ";
sql_p = sql_p + " ,( select c_name from tbl_apply_field where c_no = a.c_part ) as c_part_name ";
sql_p = sql_p + " ,( select c_use_field from tbl_apply_field where c_no = a.c_part ) as c_part_field ";
sql_p = sql_p + " from tbl_point_project a ";
sql_p = sql_p + " inner join tbl_project b on b.c_no = a.c_project_no ";
sql_p = sql_p + " where a.c_home = " + c_home + " and a.c_maker = 0 and a.c_now = 1 ";
String c_part_name = "";
String c_part_field = "";
ResultSet rs_p = stmt.executeQuery(sql_p);
if(rs_p.next()){
c_project_no = rs_p.getInt("c_project_no");
c_point_project_no = rs_p.getInt("c_no");
c_part_name = rs_p.getString("c_part_name");
c_part_field = rs_p.getString("c_part_field");
%>