ASP页面修改循环里 怎么相加

Question

<%
sql = "SELECT * FROM Accounts.dbo.view_2 where IsAndroid = 0"
set rs = conn.execute(sql)

if not rs.eof then
do while not rs.eof
userid=rs("USERID")
set rxsum=conn.execute("SELECT SUM(Score) FROM Accounts.dbo.View_3 where userid="&userid)
score=rxsum(0)
%>

<td><%=userid%></td>
<td><%=rs("ACCOUNTS")%></td>
<td><%=score%></td>
<td><%=news%></td>

<%
rs.movenext
loop
else
%>

<%=score%>这个值在循环后怎么相加？

相加后显示<%=news%> 这里

Answer 1

 <%
sql = "SELECT * FROM Accounts.dbo.view_2 where IsAndroid = 0"
set rs = conn.execute(sql)

if not rs.eof then

news=0
do while not rs.eof
userid=rs("USERID")
set rxsum=conn.execute("SELECT SUM(Score) FROM Accounts.dbo.View_3 where userid="&userid)
score=rxsum(0)
news=news+score''''''''''''
%>

<td><%=userid%></td>
<td><%=rs("ACCOUNTS")%></td>
<td><%=score%></td>
<!--<td><%=news%></td>-->

<%
rs.movenext
loop
%>
<td><%=news%></td><!--应该是放这里吧。。你的是总计，放到同一条记录里面干嘛？-->
<%
else
%>