查询数据库前5条输出的两个问题

来源：百度知道 编辑：UC知道 时间：2024/06/22 01:41:47
rs.open "select top 5 * from m1 order by m1_id ",conn,1,1，
1.调用之后怎么用Response.write输出？
2.我想要把这5条，每一条都放在<div></div>中，怎么实现？
麻烦大家帮我把代码写出来，我是新手~谢谢~

<%
response.write "<div>"
do while not rs.eof
for i=0 to rs.fields.count-1
response.write rs(i)
next
rs.movenext
response.write "<br>"
loop
response.write "</div>"
%>

是这样吧

<%
while not rs.eof
response.write "<div>"
for i=0 to rs.recordcount-1
response.write rs.fields.item(i).value
next
response.write"</div>"
rs.movenext
wend

%>

1.response.write rs("name")

2.
<%do while not rs.eof%>
<div><%=rs("name")</div>
<%rs.movenext
loop%>

name = 数据列名