<%
if newsmove<>1 then
sqlprom = "select top 20 * from News where online=true and now()=PubDate and NewsClass<>'' order by uup desc,Pubdate desc"
else
sqlprom = "select top 7 * from News where online=true and now()=PubDate and NewsClass<>'' order by uup desc,Pubdate desc"
end if
set rsnews=Server.CreateObject("ADODB.RecordSet")
rsnews.open sqlprom,conn,1,1
if rsnews.eof and rsnews.bof then
response.write "暂时没有新闻公告"
else
if newsmove<>1 then
response.write ""
response.write " "
end if
Do while Not rsnews.eof
response.write ""
Response.write "·"&lleft(rsnews("NewsTitle"),44)
response.write " "
rsnews.movenext
loop
if newsmove<>1 then
response.write " "
response.write " "
response.write " "
end if
%>
|
<%
end if
rsnews.close
set rsnews=nothing
%>
|
|
|