急急遍历结果集的问题

summily 2009-06-12 02:14:02

怎么将一个结果集的数据以表格的形式都输出到页面上啊

if not rs.eof then
response.write("<tr><td>"&rs("name")&"</td><td>"&rs("object")&"</td><td>"&rs("plan")&"</td></tr>")
rs.movenext

...全文

46 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

summily 2009-06-12

打赏
举报

不行啊
<body>
<%
pep = request.form("name")
yeara = trim(request.Form("year"))
quarter = trim(request.form("quarter"))
set rs=server.createobject("adodb.recordset")
sql="select * from score where pep='"&pep&"' and year='"&yeara&"' and quarter = '"&quarter&"'"
rs.open sql, conn, 1, 1

%>

<table class="Tab">
<tr>
<td width="10%" align="center">评价人</td>
<td width="12%" align="center">
团队目标和方向</td>
<td width="9%" align="center">
团队计划</td>
<td width="11%" align="center">
团队交流</td>
<td width="11%" align="center">
团队信任</td>
<td width="11%" align="center">
团队支持</td>
<td width="10%" align="center">
团队责任</td>
<td width="10%" align="center">
团队成长</td>
<td width="9%" align="center">
团队学习</td>
<td width="7%" align="center">
合计</td>

</tr>
<%

Do While not rs.eof
response.write("<tr><td>"&rs("name")&"</td><td>"&rs("object")&"</td><td>"&rs("plan")& "</td><td>"&rs("ac")&"</td><td>"&rs("believe")&"</td><td>"&rs("support")&"</td><td>"&rs("duty")&"</td><td>"&rs("shape")&"</td><td>"&rs("study")&"</td><td>"&rs("score")&"</td></tr>")
rs.movenext
Loop

%>

</table>
<%

rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<input type="button" onClick="backSubmit()" value="返回">
</body>

sy_binbin 2009-06-12

打赏
举报

do while nor rs.eof
……………………
rs.movenext
loop

hookee 2009-06-12

打赏
举报





Response.Write "<table>"

Do While not rs.eof    

  response.write "<tr><td>" & rs("name") & "</td><td>" & rs("object") & "</td><td>" & rs("plan") & "</td></tr>"

  rs.movenext

Loop

rs.close

Response.Write "</table>"

conn.close

set conn = nothing