|
<%
set rs=server.createobject("adodb.recordset")
sql="select * from ServeInfo where ServeOrder=1"
rs.open sql,conn,1,1
if rs.eof then
response.write "The material is being increased......"
else
if len(rs("ServeContent"))>260 then
response.write left(rs("ServeContent"),260)&"... ..."
else
response.Write rs("ServeContent")
end if
end if%>
More>> |
|
|
<% set rs=server.createobject("adodb.recordset")
sql="select top 4 * from News where class='001' order by datetime desc"
rs.open sql,conn,1,1
for i=1 to 4
if rs.eof then
exit for
end if
%>
<%
rs.movenext
next
rs.close
set rs=nothing
%> |
|
|