<% rs.close() set rs=nothing sql="select * from products where hot_news="&True&" and type_one_id=30 order by num desc" set rs=conn.execute(sql) For i=1 to 2 if rs.eof then exit for end if cn_content=rs("cn_content") %>