一个奇怪的现象:一个语句中同一个变量居然有不同的值!

lynn0821 2004-02-11 12:42:46

<html>
<head>
<title>Welcome 2o [T] Try...</title>
</head>
<body>
<%

Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=e:/mcs02/ebussiness/messages.mdb"
CommandText="select * from messages"
Set rs=Conn.Execute(CommandText,20,1)

Response.write"<marquee direction=up>"
While NOT rs.EOF

For i=0 to rs.Fields.Count-1
Response.write rs(i).value&"<br>"
Next
rs.MoveNext
Wend

Response.write"</marquee>"
%>

<%

CommandText1="Select short_news from news"
Set rs1=Conn.Execute(CommandText1,20,1)

Response.write"<table border=1>"
While NOT rs1.EOF
Response.write"<tr>"
For j=0 TO rs1.Fields.Count-1
Response.write "<td><a href=news.asp?name="&j&">"&rs1(j).value&"</a></td>"
Next
rs1.MoveNext
Response.write"</tr>"
Wend
Response.write"</table>"
%>
<%
Set Conn=nothing
%>
</body>
</html>

奇怪的是:
For j=0 TO rs1.Fields.Count-1
Response.write "<td><a href=news.asp?name="&j&">"&rs1(j).value&"</a></td>"
Next
rs1.MoveNext
其中的Response.write "<td><a href=news.asp?name="&j&">"&rs1(j).value&"</a></td>"
这一句子中的两个j 居然不同值?!
因为每个链接都转到了news.asp?name=0那里,
而后面的rs1(j).value却能从数据库里调出不同的值
奇怪啊!为什么呢?
是我这样写的不规范吗?

换了do while……loop语句也是同样的问题……

...全文