<% 'Call UserAuth(Session("id")) '### 권한 체크(회원 로그인을 안했으면 돌아가기) Dim idx, userAge, subject, careTerm, 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_DIET_REVIEW" '### DB 테이블명 idx = Trim(Request("idx")) SQL = "SELECT userId, idx, userAge, subject, careTerm, 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") careTerm = RS("careTerm") 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 %>
관리기간	<%=careTerm%>
<%=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 %>