<% 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 " " 'response.write " " response.write "" Rs.Open query, adoConn, 1 do while not Rs.eof response.write "" response.write " " response.write " " response.write " " response.write " " response.write " " 'response.write " " response.write "" Rs.movenext loop Rs.close response.write "
프로젝트면접원대여기간대여신청자기록일시
[" & Rs("P_CHILD_SN") & "] " & Rs("P_SUBJECT") & "" if Rs("MAN_ID") <> "" Then response.write "[" & Rs("MAN_ID") & "] " & Rs("M_NAME") End if response.write "" & Rs("USE_ST_DT") & " ~ " & Rs("USE_ED_DT") & "" & Rs("INSERT_USER_NAME") & "" & Rs("MODIFY_DT") & "" 'if Rs("INSERT_USER") = Cstr(Session("User_Number")) Then ' response.write "" 'End if 'response.write "
" %>