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 "<table border=1>" Response.Write "<tr><th>属性名</th>" Response.Write "<th>値</th></tr>" For i=0 to objRs.Properties.Count - 1 Set objProp = objRs.Properties.Item(i) Response.Write "<tr><td>" Response.Write objProp.Name Response.Write "</td><td>" Response.Write objProp.Value Response.Write "</td></tr>" Next Response.Write "</table>" Set objProp = Nothing Set objRs = Nothing Set objCmd = Nothing objConn.Close Set objConn %>
Topへ