<% sql1="select top 8 * from Product1 where bigclassname='公司新闻' and Passed=True And Elite=True order by -num,-articleid"
Set rs1= Server.CreateObject("ADODB.Recordset")
rs1.open sql1,conn,1,1
%>
<% sql1="select top 8 * from Product1 where bigclassname='业内咨讯' and Passed=True And Elite=True order by -num,-articleid"
Set rs1= Server.CreateObject("ADODB.Recordset")
rs1.open sql1,conn,1,1
%>
<%
set rs_Product=server.createobject("adodb.recordset")
sqltext="select top 3 * from Product where Passed=True And Elite=True order by -num,articleid"
rs_Product.open sqltext,conn,1,1
%>