<%
set rs=server.createobject("adodb.recordset")
sql2="select top 5 boardid,topicid,title from topic where locktopic<2 ORDER BY topicID desc"
rs.open sql2,conn,1,1
if not(rs.eof and rs.bof) then
do while not rs.eof
response.write "·" & ""
if len(rs("title"))>26 then
response.write left(htmlencode(replace(rs("title"),chr(10)," ")),26)&"... "
else
response.write htmlencode(rs("title"))& " "
end if
rs.movenext
loop
end if
rs.close
%>
☆热门讨论
<%
sql1="select top 5 TopicID,boardid,title from Topic where locktopic<2 and hits>10 ORDER BY hits desc"
rs.open sql1,conn,1,1
if not(rs.eof and rs.bof) then
do while not rs.eof
response.write "·" & ""
if len(rs("title"))>26 then
response.write left(htmlencode(replace(rs("title"),chr(10)," ")),26)&"... "
else
response.write htmlencode(rs("title"))& " "
end if
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
建设部副部长傅雯娟在高等学校土建学科教学指导委员会会议上的讲话
