% device_id = request("device_id") Response.CharSet = "EUC-KR" '한글 Response.AddHeader "Pragma","no-cache" Response.AddHeader "cache-control", "no-staff" Response.Expires = -1 query = "" query = query & " select ISNULL(DU.P_CHILD_SN, '') AS P_CHILD_SN, " query = query & " ISNULL(VPM.P_SUBJECT, '') AS P_SUBJECT, " query = query & " ISNULL(DU.MAN_ID, '') AS MAN_ID, " query = query & " ISNULL(M.M_NAME, '') AS M_NAME, " query = query & " ISNULL(DU.USE_ST_DT, '') AS USE_ST_DT, " query = query & " ISNULL(DU.USE_ED_DT, '') AS USE_ED_DT, " query = query & " ISNULL(DU.D_NO, '') AS D_NO, " query = query & " ISNULL(P.p_name, '') AS INSERT_USER_NAME, " query = query & " DU.INSERT_DT, DU.MODIFY_DT " query = query & " from T_DEVICE_USE_NEW DU " query = query & " JOIN T_DEVICE_NEW D ON D.ID = DU.DEVICE_ID " query = query & " LEFT JOIN project2.dbo.T_PROJECT_METHOD VPM ON DU.P_CHILD_SN = VPM.p_child_sn " query = query & " LEFT JOIN project2.dbo.man M ON DU.MAN_ID = M.new_id " query = query & " LEFT JOIN project2.dbo.person P ON DU.INSERT_USER = P.p_no " query = query & " WHERE D.ID = " & device_id & " AND DU.USE_YN <> 'Y' " query = query & " ORDER BY DU.MODIFY_DT DESC " response.write "
| 프로젝트 | " response.write "면접원 | " response.write "대여기간 | " response.write "대여신청자 | " response.write "기록일시 | " 'response.write "" response.write " |
| [" & Rs("P_CHILD_SN") & "] " & Rs("P_SUBJECT") & " | " response.write "" if Rs("MAN_ID") <> "" Then response.write "[" & Rs("MAN_ID") & "] " & Rs("M_NAME") End if response.write " | " response.write "" & Rs("USE_ST_DT") & " ~ " & Rs("USE_ED_DT") & " | " response.write "" & Rs("INSERT_USER_NAME") & " | " response.write "" & Rs("MODIFY_DT") & " | " 'response.write "" 'if Rs("INSERT_USER") = Cstr(Session("User_Number")) Then ' response.write "" 'End if 'response.write " | " response.write "