 |
<%set newsrs=Server.CreateObject("ADODB.RecordSet")
newsrs.open "select top 5 NewsID,Title,FileName from News where CategoryID='27,44' order by NewsID desc",newsconn,1,1
do while not newsrs.eof
if len(trim(newsrs("Title")))>18 then%>
<%="·"&left(newsrs("Title"),16)&".."&" "%>
<%else%>
<%="·"&newsrs("Title")&""&" "%>
<%end if%>
<%newsrs.movenext
loop
newsrs.close
set newsrs=nothing
%>
|
|
 |
 |
<%set newsrs=Server.CreateObject("ADODB.RecordSet")
newsrs.open "select top 5 NewsID,Title,FileName from News where CategoryID='8,11' order by NewsID desc",newsconn,1,1
do while not newsrs.eof
if len(trim(newsrs("Title")))>18 then%>
<%="·"&left(newsrs("Title"),16)&".."&" "%>
<%else%>
<%="·"&newsrs("Title")&""&" "%>
<%end if%>
<%newsrs.movenext
loop
newsrs.close
set newsrs=nothing
%>
|
|
 |
|