代码如下，结果只显示符合条件的最后一条记录？请高手指教
<%
sql = "select * from article_class where flag <> 0 and grade <> 0 order by Unid asc"
set rs = conn.execute(sql)
Do while Not rs.eof
XL=rs(1)
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
response.write XL
%>
參考答案:因你的response.write (XL)没有放去循环．
改成这样：
sql = "select * from article_class where flag <> 0 and grade <> 0 order by Unid asc"
set rs = conn.execute(sql)
Do while Not rs.eof
XL=rs(1)
response.write (XL)"<br>"
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
