HOME > <%=left_location_name%> > <%=board_name%>
<% sql = "select * from board where idx = '"&idx&"' " rs.open sql,dbcon If rs.eof Then rs.close dbcon.close Call caution_go("존재하지 않는 게시물입니다.",-1) Else r_write_id = rs("member_id") r_title = rs("title") r_name = rs("name") r_reg_date = rs("reg_date") r_readnum = rs("readnum") + 1 r_content = rs("content") r_ucc_link = rs("ucc_link") r_link1 = rs("link1") r_link2 = rs("link2") r_write_ip = rs("write_ip") rs.close End If '조회수 업데이트 sql = "update board set readnum="&r_readnum&" where idx='"&idx&"' " dbcon.Execute(sql) if r_reg_date <> "" then r_reg_date = formatdatetime(r_reg_date, 2) & " " & formatdatetime(r_reg_date, 4) end if sql = "select * from board_file with(nolock) where b_idx='"&idx&"' " rs.open sql,dbcon file_chk = 0 if not rs.eof then file_data = rs.getrows rs.close file_chk = 1 file1_img = "" file2_img = "" For i=0 To UBound(file_data, 2) f_idx = file_data(0, i) b_idx = file_data(2, i) file_num = file_data(3, i) org_name = file_data(4, i) file_name = file_data(5, i) download = file_data(6, i) file_size = file_data(7, i) f_reg_date = file_data(8, i) org_ext = LCase(Mid(org_name, InStrRev(org_name, ".") + 1)) If org_ext = "jpg" Or org_ext = "jpeg" Or org_ext = "bmp" Or org_ext = "gif" Or org_ext = "png" Then if file_num = 1 then file1_img = "" else file2_img = "" end if end if Next Else rs.close end if %>