<% plusSql = ""; plusSql += " ( "; plusSql += " SELECT * FROM KJC_Board WHERE board_type='vos' AND board_show='y' AND board_thumbnail='y' "; plusSql += " UNION "; plusSql += " SELECT * FROM KJC_Board WHERE 1=1 "+wh+" "; plusSql += " ) a "; plusSql += " LEFT OUTER JOIN "; plusSql += " ( "; plusSql += " SELECT "; plusSql += " * "; plusSql += " FROM ( "; plusSql += " SELECT "; plusSql += " * "; plusSql += " FROM "; plusSql += " KJC_File "; plusSql += " ORDER BY file_sort ASC "; plusSql += " )AS a "; plusSql += " GROUP BY file_board_idx "; plusSql += " )AS KJC_File ON board_idx=file_board_idx "; sql += " SELECT "; sql += " board_thumbnail "; sql += " ,board_idx "; sql += " ,board_sub_type,board_sub_type2,board_sub_type3 "; sql += " ,board_title "; sql += " ,board_write_name "; sql += " ,DATE_FORMAT(board_extra_day,'%Y-%m-%d')AS board_extra_day "; sql += " ,board_hit_count "; sql += " ,board_show "; sql += " ,p_notice "; // 댓글유무 sql += " FROM "; sql += plusSql; sql += " ORDER BY (CASE WHEN board_thumbnail='y' THEN 1 ELSE 2 END),board_extra_day DESC, board_idx DESC "; sql += " limit "+(page_list_count*(paging_num-1))+","+page_list_count+""; // out.println(sql); vo_list_count = GLOBAL_ListTotalCount(plusSql,""); int vo_list_num = vo_list_count-(page_list_count*(paging_num-1)); ArrayList>voList=ExecWithRs(sql); if(voList.size()>0){ for(int i=0; i <%if(nCheck.equals("y")){%> <%}else{%> <%}%> <% vo_list_num--; } }else{ %> <% } %>

お客さまの声 list

No.	区分	事業分類	タイトル	登録者	登録日	Hit
공지	<%=vo_list_num%>	<%if(voSubType1.equals("vd1")){out.println("문의");}else if(voSubType1.equals("vd2")){out.println("건의");}else if(voSubType1.equals("vd3")){out.println("칭찬");}%>	<%if(voSubType2.equals("vb1")){out.println("인재양성(人材養成)");}else if(voSubType2.equals("vb2")){out.println("기술지도(技術指導)");}else if(voSubType2.equals("vb3")){out.println("비즈니스매칭(ビジネスマッチング)");}else if(voSubType2.equals("vb4")){out.println("산업통상협력(産業通商協力)");}else if(voSubType2.equals("vb5")){out.println("기타(その他)");}%>	<%if(GLOBAL_Over_Date("d",wDay,getDate(1))<8){%>new<%}%><%=voTit%>	<%=voWriteName%>	<%=wDay%>	<%=voHit%>
照会されたデータがありません。