<%set rs=server.createobject("adodb.recordset") sql="select top 10 * from SW_article where channelid<>21 and channelid<>22 order by rnd(articleid) desc" rs.open sql,conn,1,1 do while not rs.eof %> <% i=i+1 rs.movenext loop %>