Refresh
コレクション更新
文法
Propertyコレクション.Refresh
機能説明
Propertyコレクション更新
使用例
<% Dim objConn, objCmd, objProp, objRs, i Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open = "sample" Set objCmd = Server.CreateObject("ADODB.Command") objCmd.ActiveConnection = objConn 'クエリ作成 objCmd.CommandText = "select * from test " Set objRs = objCmd.Execute objRs.Properties.Refresh '表示 Response.Write "
" Response.Write "
属性名
" Response.Write "
値
" For i=0 to objRs.Properties.Count - 1 Set objProp = objRs.Properties.Item(i) Response.Write "
" Response.Write objProp.Name Response.Write "
" Response.Write objProp.Value Response.Write "
" Next Response.Write "
" Set objProp = Nothing Set objRs = Nothing Set objCmd = Nothing objConn.Close Set objConn %>
Topへ