| 行业新闻>> |
<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("activeweb/mynews.mdb")
conn.open connstr
sql="select top 10 * from article where typeid=1 order by newsid desc"
rs.open sql,conn,3,3
do while not(rs.bof or rs.eof)
%>
| |
<%
rs.movenext
loop
%>
|
|
| 新闻动态>> |
<%
set conn=server.CreateObject("adodb.connection")
set rs1=server.CreateObject("adodb.recordset")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("activeweb/mynews.mdb")
conn.open connstr
sql="select top 10 * from article where typeid=2 order by newsid desc"
rs1.open sql,conn,3,3
do while not(rs1.bof or rs1.eof)
%>
| |
<%
rs1.movenext
loop
%>
|
