<%sql="select top 8 id,c_name from Hotelb order by id desc" Set rs=Server.CreateObject("ADODB.RecordSet") rs.open sql,conn,1,1 if rs.eof then response.write "暂时还没有任何信息!" Else do while not rs.eof%>
.html"> <%if len(rs("c_name"))>16 then%> <%=left(rs("c_name"),16)%>... <%else%> <%=rs("c_name")%> <%end if%>
<% rs.movenext loop end if rs.close%>
 
<%sql="select top 8 id,x_name from xianlu order by id desc" Set rs=Server.CreateObject("ADODB.RecordSet") rs.open sql,conn,1,1 if rs.eof then response.write "暂时还没有任何信息!" Else do while not rs.eof%>
.html"> <%if len(rs("x_name"))>16 then%> <%=left(rs("x_name"),16)%>... <%else%> <%=rs("x_name")%> <%end if%>
<% rs.movenext loop end if rs.close%>
 
  航空物流
<%set rs=server.createobject("adodb.recordset") rs.open "select top 3 * From wuliu",conn,1,1 if err.number<>0 then response.write "数据库中无数据!" end if do while not rs.eof %>
.html target=_blank><%=rs("Title")%>

<%=rs("Content")%>

<% rs.movenext loop rs.close set rs=nothing %>