Question

asp代码 set rs=conn.execute(sql) 里 对rs的操作

如题
sql = “select [aa],[bb] from [Name]”
set rs = conn.execute(sql)
之后
怎么把rs里的值显示出来

Answer 1

sql = “select [aa],[bb] from [Name]”
set rs = conn.execute(sql)
do until rs.eof
response.write rs("aa") & " / " & rs("bb") & "<br>"
rs.movenext
loop

Answer 2

do While Not Rs.eof
Response.Write(Rs("aa")&"----"&Rs("bb"))
Rs.MoveNext
Loop
'关闭记录集
Rs.Close
Set Rs = Nothing

Answer 3

循环，rs("字段名")