<% Dim idx, subject, writeDate, contents, fileName1, fileSize1, fileName2, fileSize2, fileName3, fileSize3, hit, gotopage Dim SQL, RS, tableName tableName = "TB_CSCENTER_STUDY" '### DB 테이블명 idx = Trim(Request("idx")) SQL = "SELECT idx, subject, writeDate, contents," SQL = SQL & " fileName1, fileSize1, fileName2, fileSize2, fileName3, fileSize3, hit," SQL = SQL & " (SELECT MAX(idx) FROM " & tableName & " WHERE idx < t1.idx ) as previdx, (SELECT MIN(idx) FROM " & tableName & " WHERE idx > t1.idx) as nextidx FROM " & tableName & " t1" SQL = SQL & " WHERE idx = " & idx Set RS = Dbcon.Execute(SQL) idx = RS("idx") subject = RS("subject") contents = RS("contents") contents = Replace(contents, chr(13) & chr(10), "
") fileName1 = RS("fileName1") fileSize1 = RS("fileSize1") fileName2 = RS("fileName2") fileSize2 = RS("fileSize2") fileName3 = RS("fileName3") fileSize3 = RS("fileSize3") writeDate = RS("writeDate") hit = RS("hit") previdx = RS("previdx") nextidx = RS("nextidx") gotopage = Trim(Request("gotopage")) If gotopage = "" Then gotopage = 1 Else gotopage = Cint(gotopage) End If '조회수 증가 SQL = "UPDATE " & tableName & " SET hit = " & hit + 1 SQL = SQL & " WHERE idx = " & idx Dbcon.Execute(SQL) RS.Close Set RS = Nothing %>

Home
고객만족센터
공부하는 유앤아이

	<%=subject%>		<%=writeDate%>	조회	<%=hit%>
<% If fileName1 <> "" Then Response.Write " " : %> <% If fileName2 <> "" Then Response.Write " " : %> <% If fileName3 <> "" Then Response.Write " " : %> <%=contents%>
<% '첨부파일 정보는 관리자만 보임. If fileName1 <> "" And Session("admin_div") > 0 Then %> 첨부파일 : <%=fileName1%> (<%=FormatNumber(fileSize1, 0)%> byte) <% End If If fileName2 <> "" And Session("admin_div") > 0 Then %> 첨부파일 : <%=fileName2%> (<%=FormatNumber(fileSize2, 0)%> byte) <% End If If fileName3 <> "" And Session("admin_div") > 0 Then %> 첨부파일 : <%=fileName3%> (<%=FormatNumber(fileSize3, 0)%> byte) <% End If %>

<% If Trim(session("admin_div")&"") = "1" Then %> <% End If %> <% If previdx <> "" Then%> <% END If %> <% If nextidx <> "" Then%><% END If %>