<% set conn= server.createobject("adodb.connection") connstr = "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("db2.mdb") conn.open connstr set rs = server.createobject ("adodb.recordset") sql = "select * from people order by id desc" rs.open sql,conn,1,1 do while not rs.eof response.write rs("id")&" | " rs.movenext loop %> |
<% set conn = server.createobject("adodb.connection") set cmd = server.createobject("adodb.command") conn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("db2.mdb") cmd.activeconnection = conn cmd.commandtext = "select * from people order by id desc" set rs = cmd.execute do while not rs.eof response.write rs("id")&" | " rs.movenext loop %> |
<% set conn = server.createobject("adodb.connection") set cmd = server.createobject("adodb.command") conn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("db2.mdb") cmd.activeconnection = conn cmd.commandtext = "select * from people order by id desc" set rs = cmd.execute rsarray = rs.getrows() for i = 0 to ubound(rsarray, 2) response.write rsarray(0, i)&" | " next %> |
如对本文有疑问, 点击进行留言回复!!
asp中Request.ServerVariables的参数集合
网友评论