% ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Query Dim Content Dim EnshuCD Dim EnshuName EnshuCD = Request("EnshuCD") If EnshuCD <> "" Then Query = "exec SPM演習取得 '" & GB_SystemCD & "', '" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then EnshuName = Content.Fields("演習名称") End If End If Dim CopyMoto CopyMoto = Request("CopyMoto") Dim TmpUserID TmpUserID = Request("UserID") 'ユーザーID・演習履歴配列作成 Dim UserID Dim UserMei Dim Rireki Dim SentakuCD ReDim UserID(0) ReDim UserMei(0) ReDim Rireki(0) ReDim SentakuCD(0) Query = "exec SPMユーザー一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '%', '%', '%', '" & Date() & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) ReDim PreServe UserID(UBound(UserID) + 1) '配列+1 ReDim PreServe UserMei(UBound(UserID)) ReDim PreServe Rireki(UBound(UserID)) ReDim PreServe SentakuCD(UBound(UserID)) UserID(UBound(UserID)) = "" & Content.Fields("学生番号") UserMei(UBound(UserID)) = "" & Content.Fields("氏名") Rireki(UBound(UserID)) = "" & Content.Fields("最終参加日時") SentakuCD(UBound(UserID)) = "" & Content.Fields("会社名称") Content.MoveNext Loop Dim TmpCnt %> <% = HtmlHeader("") %>
<% = HtmlFooter %>