<%set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from Article order by ArticleID desc",conn,1,1
if not rs1.bof then
rs1.movefirst
end if
do while not rs1.eof%> " title="<%=rs1("Title")%>"><%=rs1("Title")%>
<%rs1.movenext
loop
rs1.close%>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from prod where 1=1 and ClassID in(1,2,3,4,5,6,7,8,9,10) order by ArticleID desc",conn,1,1
if not rs.bof then
rs.movefirst
end if
do while not rs.eof%> " title="<%=rs("prodName")%>"><%=rs("prodName")%>
<%rs.movenext
loop
rs.close%>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from prod where 1=1 and ClassID in(11) order by ArticleID desc",conn,1,1
if not rs.bof then
rs.movefirst
end if
do while not rs.eof%> " title="<%=rs("prodName")%>"><%=rs("prodName")%>
<%rs.movenext
loop
rs.close%>