<% Option Explicit %> <% Response.Buffer = True Response.Expires = -1 Response.AddHeader "Pragma", "no-cache" Response.AddHeader "cache-control", "no-store" If IsEmpty(Session("SESSION_ID")) Then Response.Redirect "timeout.htm" End If %> <% Dim cn, rs, i, strSQL Dim RecCount Dim strKey Dim objBasp Dim iMuse Dim rs2 Dim strImg strKey = Request.ServerVariables("QUERY_STRING") strSQL = "SELECT * FROM V_K_IKHOU WHERE IKHOU_CH_ID = '"& strKey &"'" Set cn = Server.CreateObject("ADODB.Connection") cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Session("MDB_A") & ";" Set rs = Server.CreateObject("ADODB.RecordSet") rs.Open strSQL, cn, 1, 1 RecCount = rs.RecordCount 'BASP21 Set objBasp = Server.CreateObject("BASP21") 'iMuse Set iMuse = Server.CreateObject("iMuse.Functions") %>

<% If RecCount > 0 Then %> <% Else %> データが見つかりません。 <% End If %> 遺跡名 <% =NullRepWSP(rs.Fields("ISEKI_CH_NM")) %> <% '写真 strSQL = "SELECT * FROM S_PHOTO WHERE DB_KBN = '遺構' AND ISKB_CH_ID = '"& strKey &"' ORDER BY ISKB_NB_SEQ" Set rs2 = Server.CreateObject("ADODB.RecordSet") rs2.Open strSQL, cn, 1, 1 If rs2.RecordCount > 0 Then strImg = MidImagepath(rs2.Fields("IMAGE_PATH")) Response.Write "" Response.Write "" Response.Write "" Set rs2 = Nothing %> <% Else %> <% End If %> 遺跡名 （ふりがな） <% =NullRepWSP(rs.Fields("ISEKI_NM_YM")) %> 遺跡所在地 <% Response.Write NullRepWSP(rs.Fields("SYOZAI_TDF")) & NullRepWSP(rs.Fields("SYOZAI_CITY_NM")) & NullRepWSP(rs.Fields("SYOZAI_OAZA")) %> 時代 <% Dim strJ If rs.Fields("J_SEKKI") = "1" Then strJ = "旧石器時代" End If If rs.Fields("J_JYOMON") = "1" Then If strJ <> "" Then strJ = strJ & "," & "縄文時代" Else strJ = "縄文時代" End If End If If rs.Fields("J_YAYOI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "弥生時代" Else strJ = "弥生時代" End If End If If rs.Fields("J_KOFUN") = "1" Then If strJ <> "" Then strJ = strJ & "," & "古墳時代" Else strJ = "古墳時代" End If End If If rs.Fields("J_KODAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "古代" Else strJ = "古代" End If End If If rs.Fields("J_TYUSEI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "中世" Else strJ = "中世" End If End If If rs.Fields("J_KINSEI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "近世" Else strJ = "近世" End If End If If rs.Fields("J_KINDAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "近代" Else strJ = "近代" End If End If If rs.Fields("J_GENDAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "現代" Else strJ = "現代" End If End If Response.Write NullRepWSP(strJ) %> 遺構の 主な時期 <% =NullRepWSP(rs.Fields("IK_MN_JIKI_NM")) %> 遺構の年代 <% =NullRepWSP(rs.Fields("IK_NENDAI_E")) %> 遺構の名称 <% =NullRepWSP(rs.Fields("IKHOU_CH_NM")) %> 遺構の名称 （ふりがな） <% =NullRepWSP(rs.Fields("IKHOU_CH_YM")) %> 説明 <% =NullRepWSP(rs.Fields("SETSUMEI_NM")) %> 　 ">