Question

asp数组赋值

set rs4= server.CreateObject("adodb.recordset")
sql4= "select * from grade"
rs4.open sql4,conn,1,1
if not rs4.eof then
do while not rs4.eof
vstart= rs4("jf_start")
vend= rs4("jf_end")
rs4.movenext
loop
为什么数据不循环呢,请高手指点,能给出具体代码最好,谢谢

Answer 1

肯定是循环了的，只不过因为你把数据赋给了变量，没有及时输出，所以只能得到最后那条数据
，改成response.write你就能看到结果
set rs4= server.CreateObject("adodb.recordset")
sql4= "select * from grade"
rs4.open sql4,conn,1,1
if not rs4.eof then
do while not rs4.eof
response.write rs4("jf_start")
response.write rs4("jf_end")
rs4.movenext
loop

Answer 2

要赋值给数组吗？不用输出的对吧？那我给你写一下赋值的吧，想输出看2楼就的可以了
set rs4= server.CreateObject("adodb.recordset")
sql4= "select * from grade"
rs4.open sql4,conn,1,1
aaa=0
if not rs4.eof then
do while not rs4.eof
vstart(aaa)= rs4("jf_start")
vend(aaa)= rs4("jf_end")
aaa=aaa+1
rs4.movenext
loop

Answer 3

do while像你那么用吗？

Answer 4

你给的是变量,所以不好用!