% 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 rs2
Dim RecCount1
Dim RecCount2
Dim MaxRec
Dim PID
Dim strKey
Dim pi
Dim t
Dim z
Dim strYear
Dim strNM
Dim iMuse
Dim RecArray
'iMuse
Set iMuse = Server.CreateObject("iMuse.Functions")
PID = Request.ServerVariables("QUERY_STRING")
strKey = PID
'報告書
strSQL = "SELECT * FROM RH_KANREN_FL WHERE REPOT_CH_ID = '" & strKey & "'"
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Session("MDB_B") & ";"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open strSQL, cn, 1, 1
MaxRec = rs.RecordCount
ReDim RecArray(MaxRec,3)
i=0
t=0
z=0
For i=1 To MaxRec
z = z + 1
RecArray(z,0)=rs.Fields("FILE_NM")
RecArray(z,1)=rs.Fields("NAIYOU")
RecArray(z,2)=rs.Fields("DATA_KIKAKU")
rs.MoveNext
Next
%>
鹿児島県埋蔵文化財情報データベース
 |
<%
Response.Write ""
Response.Write ""
Response.Write MaxRec
Response.Write " 件該当しました。"
Response.Write ""
Response.Write ""
Response.Write " "
If MaxRec > 0 Then
%>
<%
Else
Response.Write " "
Response.Write " "
Response.Write " "
Response.Write " "
Response.Write " "
Response.Write " "
End If
'破棄
Set rs = Nothing
cn.Close
%>
|
|
 |