<% 'データベース接続 Set ObjConn = Server.CreateObject("ADODB.Connection") ObjConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & _ Server.Mappath("scripts/fujikawa.mdb") '値をセットします。 date_time = Now jikoku = hour(Now) ip = Request.ServerVariables("REMOTE_ADDR") ref = Request.ServerVariables("HTTP_REFERER") If ref = "" Then ref = "http://www.lausanne.jp" End If 'データを追加します。 StrSQL = "insert into log (" StrSQL = StrSQL & " date_time, " StrSQL = StrSQL & " jikoku, " StrSQL = StrSQL & " ip, " StrSQL = StrSQL & " ref " StrSQL = StrSQL & ") values (" StrSQL = StrSQL & "#" & date_time & "#," StrSQL = StrSQL & jikoku & "," StrSQL = StrSQL & "'" & ip & "'," StrSQL = StrSQL & "'" & ref & "'" StrSQL = StrSQL & ")" ObjConn.Execute(StrSQL) 'データベース接続解除 ObjConn.Close Set ObjConn = Nothing %> <% Set objFile = Server.CreateObject("Scripting.FileSystemObject") sPathCountFile = Server.MapPath("Scripts/counter.dat") On Error Resume Next Set strmFile = objFile.OpenTextFile(sPathCountFile, 1, FALSE) If Err.Number > 0 Then '***** 初回起動? iCount = 0 dtOld = Date() iCountT = 0 iCountY = 0 Else '***** カウントファイルの読み込み iCount = strmFile.ReadLine dtOld = CDate(strmFile.ReadLine) iCountT = strmFile.ReadLine iCountY = strmFile.ReadLine End If '***** カウント処理 If dtOld <> Date() Then '***** 日付が変わった? dtOld = Date() iCountY = iCountT iCountT = 0 End If iCount = iCount + 1 iCountT = iCountT + 1 strmFile.Close '***** カウントファイルへ書き込み Set strmFile = objFile.OpenTextFile(sPathCountFile, 2, TRUE) strmFile.WriteLine iCount strmFile.WriteLine dtOld strmFile.WriteLine iCountT strmFile.WriteLine iCountY strmFile.Close %>