Question

asp 循环中定义变量

<%
for i=1 to rs.recordcount
set rss=server...... (一个recordset)
rss.open ....
do while not rss.eof

'这边我需要定义i个变量,把rss中某一个字段的值递加
'不知道这边应该怎么写

rss.movenext
loop
next
%>

大侠,救命!
sum 变量不止一个的啊 一共rs.recordcount个 然后一个个把他们输出

Answer 1

<%
dim sum
sum = ""
for i=1 to rs.recordcount
set rss=server...... (一个recordset)
rss.open ....
do while not rss.eof

sum=sum+"{$}"+rss("字段名")

rss.movenext
loop
next

dim temp
temp=split(sum,"{$}")
response.write "一共有"&ubound(temp)+1&"条记录"
for i=0 to ubound(temp)
response.write temp(i)
next
%>
split和replace都是很有用的函数。

Answer 2

<%
dim sum
sum = 0
for i=1 to rs.recordcount
set rss=server...... (一个recordset)
rss.open ....
do while not rss.eof

sum=sum+rss("字段名")

rss.movenext
loop
next
%>

Answer 3

那么就用数组
然后用join函数连接起来就好了
到时候直接输出数组