b=request.Form("aa")
sql1="select * from cibiao"
set rs1=conn.execute(sql1)
a=Split(b,",")
For i=0 To UBound(a)
Do While Not rs1.eof
response.write a(i)&"<br>"
response.write rs1("title2")&"<br>"
If a(i)=rs1("title2") Then
response.write rs1(2).value&"<br>"
Exit do
End If
rs1.movenext
Loop
rs1.movefirst
Next
为什么if语句在for语句第二次循环时不执行呢？希望各位师哥师姐能帮帮忙！谢谢！
2006-06-18 13:03
2006-06-18 21:36
set rs1=conn.execute(sql1)
把这一句话分成两句来写
Set rs1=Server.CreateObject("ADODB.RecordSet")
rs1.Open sq;1,conn,1,3
这样写呢？
2006-06-18 21:47
b=request.Form("aa")
sql1="select * from cibiao"
set rs1=conn.execute(sql1)
a=Split(b,",")
For i=0 To UBound(a)
Do While Not rs1.eof
response.write a(i)&"<br>"
response.write rs1("title2")&"<br>"
If a(i)=rs1("title2") Then
response.write rs1(2).value&"<br>"
Exit do
End If
rs1.movenext
Loop
rs1.movefirst'己经把记录指向下一条了，怎么又返回第一条？
Next
为什么if语句在for语句第二次循环时不执行呢？希望各位师哥师姐能帮帮忙！谢谢！
2006-06-19 14:35
