<% 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 K_ISEKI WHERE ISEKI_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 %> Site ID <% =InsCrLf(NullRepWSP(rs.Fields("ISEKI_CH_ID")),40) %> <% '写真 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 %> Site Name <% =InsCrLf(NullRepWSP(rs.Fields("ISEKI_NM_EG")),40) %> Site Location <% Dim strAddr 'strAddr = rs.Fields("SYOZAI_TDF_EN") & rs.Fields("SYOZAI_CITY_EN") & rs.Fields("SYOZAI_OAZA_EN") strAddr = rs.Fields("SYOZAI_OAZA_EN") & ", " & rs.Fields("SYOZAI_CITY_EN") & ", " & rs.Fields("SYOZAI_TDF_EN") Response.Write InsCrLf(NullRepWSP(strAddr),40) %> Site Location (Latitude) <% =InsCrLf(NullRepWSP(rs.Fields("IDO_EN")),40) %> Site Location (Longitude) <% =InsCrLf(NullRepWSP(rs.Fields("KEIDO_EN")),40) %> Site Location (Altitude) <% =InsCrLf(NullRepWSP(rs.Fields("HYOKO_EN")),40) %> <% '報告挿図 strSQL = "SELECT * FROM K_RPTZH WHERE DBSE_CH_KBN = '遺跡' AND ISKBS_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("GAZ_CH_PATH")) Response.Write "" Response.Write "" Response.Write "" Set rs2 = Nothing %> <% Else %> <% End If %> Site Type <% =InsCrLf(NullRepWSP(rs.Fields("SYUBETSU_EN")),40) %> Era <% Dim strJ If rs.Fields("SEKKI") = "1" Then strJ = "Paleolithic Era" End If If rs.Fields("JOUMON") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Jomon Era" Else strJ = "Jomon Era" End If End If If rs.Fields("YAYOI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Yayoi Era" Else strJ = "Yayoi Era" End If End If If rs.Fields("KOFUN") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Kohun Era" Else strJ = "Kohun Era" End If End If If rs.Fields("KODAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Kodai Era" Else strJ = "Kodai Era" End If End If If rs.Fields("TYUSEI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Chusei Era" Else strJ = "Chusei Era" End If End If If rs.Fields("KINSEI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Kinsei Era" Else strJ = "Kinsei Era" End If End If If rs.Fields("KINDAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Kindai Era" Else strJ = "Kindai Era" End If End If If rs.Fields("GENDAI") = "1" Then If strJ <> "" Then strJ = strJ & "," & "Gendai Era" Else strJ = "Gendai Era" End If End If Response.Write InsCrLf(NullRepWSP(strJ),40) %> Main Period <% =InsCrLf(NullRepWSP(rs.Fields("ISK_MAIN_JIKI_EN")),60) %> Main Date <% =InsCrLf(NullRepWSP(rs.Fields("MAIN_NENDAI")),60) %> Description <% =InsCrLf(NullRepWSP(rs.Fields("SETSUMEI_EN")),60) %> Main Features <% =InsCrLf(NullRepWSP(rs.Fields("MAIN_KENS_IKH_EN")),60) %> Main Artifacts <% =InsCrLf(NullRepWSP(rs.Fields("MAIN_SYUT_IBT_EN")),60) %> <% If Session("SEARCH_TYPE") <> "ZENBUN" Then %> "> <% Else %> "> <% End If %>