<% 'Call UserAuth(Session("id")) '### �� üũ(ȸ�� α�� ư��) Dim idx, userAge, subject, writeDate, contents, fileName1, fileSize1, fileName2, fileSize2, hit, branchCode Dim SQL, RS, tableName If Len(Session("simple_name"))+Len(Session("user_id")) < 1 Then RESPONSE.WRITE ExecJavaAlert("�α�� ̿��ּ��.",0) RESPONSE.End End If tableName = "TB_PHOTO_REVIEW" '### DB ��̺�� idx = Trim(Request("idx")) SQL = "SELECT userId, idx, userAge, subject, writeDate, contents, fileName1, fileSize1, fileName2, fileSize2, hit, branchCode," 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") uesrId = RS("userId") userAge = RS("userAge") 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") writeDate = RS("writeDate") hit = RS("hit") branchCode = RS("branchCode") previdx = RS("previdx") nextidx = RS("nextidx") '��ȸ�� SQL = "UPDATE " & tableName & " SET hit = " & hit + 1 SQL = SQL & " WHERE idx = " & idx Dbcon.Execute(SQL) RS.Close Set RS = Nothing %>

��ؾ��

Home
��
�ü��Ļ��

��	<%=subject%>	<% If branch_Code = "U001" Then %> �� <% End If %> <% If branch_Code = "U003" Then %> �� <% End If %> <% If branch_Code = "U005" Then %> �� <% End If %> <% If branch_Code = "U006" Then %> �սʸ�� <% End If %> <% If branch_Code = "U004" Then %> �Ǳ�� <% End If %> <% If branch_Code = "U002" Then %> �� <% End If %> <% If branch_Code = "U007" Then %> �� <% End If %> <% If branch_Code = "U008" Then %> �� <% End If %> <% If branch_Code = "U009" Then %> �� <% End If %>
<%=contents%> <% If fileName1 <> "" Then Response.Write " " 'Response.Write "[BEFORE]" End If %> <% If fileName2 <> "" Then Response.Write " " 'Response.Write "[AFTER]" End If %>

<% If Session("admin_div") > 0 Or Trim(Session("user_id")) = uesrId Then %> <% End If %> <% If previdx <> "" Then%> <% END If %> <% If nextidx <> "" Then%><% END If %>