% 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_IBUTU WHERE IBUTU_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
%>
| 遺跡名 |
<% =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"))
%>
|
| 遺物の名称 |
<% =NullRepWSP(rs.Fields("IBUTSU_CH_NM")) %> |
遺物の名称 (ふりがな) |
<% =NullRepWSP(rs.Fields("IBUTSU_CH_YM")) %> |
| 遺物の時期1 |
<% =NullRepWSP(rs.Fields("IB_JIKI1_NM")) %> |
| 遺物の年代 |
<% =NullRepWSP(rs.Fields("IB_NENDAI")) %> |
| 説明 |
<% =NullRepWSP(rs.Fields("SETSUMEI_NM")) %> |
">
|
<%
Else
%>
データが見つかりません。
<% End If %>
|
 |