<%set rs=server.createobject("adodb.recordset")
sql="select * from news where pid=1030 order by id desc"
rs.open sql,conn,1,3%>
<%set rs=server.createobject("adodb.recordset")
sql="select top 6 * from news where pid=1031 order by id desc"
rs.open sql,conn,1,3%>
<%do while not rs.eof%>
">
<%if len(rs("title"))>10 then
response.Write(left(rs("title"),9))&".. "
else
response.Write(rs("title"))&" "
end if%>
|
<%set rs=server.createobject("adodb.recordset")
sql="select top 6 * from news where pid=1029 order by id desc"
rs.open sql,conn,1,3%>
<%do while not rs.eof%>
| "> <%if len(rs("title"))>12 then response.Write(left(rs("title"),12))&".." else response.Write(rs("title")) end if%> |



"
else
response.Write(rs("title"))&" 