<%
sql="select top 5 * from notice order by insertdate desc"
rsnotice.open sql,conn,1,1
%>
|
|
|
|
|
|
|
| <%
sql="select * from shiyebu"
rsclass.open sql,conn,1,1
%><%do while not rsclass.eof%>
<%rsclass.movenext
loop
rsclass.close
set rsclass=nothing
%> | |
|
|
|
|
|
|
|
| |
|
|
<%
set rspic=server.CreateObject("adodb.recordset")
sql="select top 2 * from picnew order by picnewID desc"
rspic.open sql,conn,1,1
%>
<%
do while not (rspic.eof or err)
%>
|
<%if len(rspic("title"))>60 then
content=left(rspic("title"),58)&"..."
else
content=rspic("title")
end if
response.Write(""&content&"")%> |
|
<%
rspic.moveNext
loop
%> |
|
泰豪新闻 更多>>> |
<% sql="select top 10 * from news where newsid = 1 order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
%>
<%if len(rs("Title"))>33 then
Title=left(rs("Title"),31)&"..."
else
Title=rs("Title")
end if
response.Write(""&title&"")%>
<%
ndate=DateAdd("d",-3,date())
if DateDiff("d",rs("insertdate"),ndate+time())<=0 then
response.Write" | "
end if
%>
[<%=rs("insertdate")%>] |
| <%rs.movenext
loop
%>
| |
|
|
|
<%
set rscp=server.CreateObject("adodb.recordset")
sql="select * from product where p_other=1 order by ArticleID desc"
rscp.open sql,conn,1,3
%>
|
|
典型用户 更多>>> |
<% set rssc=server.CreateObject("adodb.recordset")
sql="select top 9 * from sc where sort_id=2 order by id desc"
rssc.open sql,conn,1,1
if rssc.eof or rssc.bof then
response.Write("没有相关信息")
end if
do while not rssc.eof
%>
<%if len(rssc("Title"))>33 then
Title=left(rssc("Title"),31)&"..."
else
Title=rssc("Title")
end if
response.Write(""&title&"")%>
<%
ndate=DateAdd("d",-3,date())
if DateDiff("d",rssc("insertdate"),ndate+time())<=0 then
response.Write" | "
end if
%>
[<%=rssc("insertdate")%>] |
|
<%rssc.movenext
loop
%>
|
|
|