<%
sql="select top 9 * from Commerce where typeid=1 order by NewsID desc"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%><%do while not rs.eof%>
|
|
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
|
<%
sql="select top 9 * from hyxx where typeid=4 order by NewsID desc"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%><%do while not rs.eof%>
|
|
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
|
<%
sql="select top 9 * from hyxx where typeid=10 order by NewsID desc"
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%><%do while not rs.eof%>
|
|
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
|