注册 登录
编程论坛 ASP技术论坛

求教!如何控制信息显示数量

bobskyyu 发布于 2011-01-28 01:01, 451 次点击
求教:

    asp中控制信息显示的条数,在首页表格中我只需要显示最新的7条,其他的都不用显示出来,不知道这代码要怎么样修改。代码如下:

<%
        objrs.open "select top 6 * from 360_news where display_bigclass=0 order by order_bigclass desc",objconn,3,1
        do while not objrs.eof
           if len(objrs("news_title"))<10 then
                my_news=objrs("news_title")
            else
                my_news=left(objrs("news_title"),10) & " ..."
            end if
            
            select case objrs("news_type")
                case 0 my_str=my_news
                case 1 my_str="<span class='text_b'>" & my_news & "</span>"
                case 2 my_str="<span class='color_blu'>" & my_news & "</span>"
                case 3 my_str="<span class='text_b color_blu'>" & my_news & "</span></b>"
                case else my_str=my_news
            end select
            
           if now-objrs("news_date")<5 then
              my_date="NEW"
           else
              my_date=""
           end if
          response.write "<li><a href='news_show.asp?id=" & objrs("id") & "'>" & my_str & "</a></li>"
            objrs.movenext
        loop
        objrs.close
%>
1 回复
#2
hams2011-01-28 08:20
做个累计数
1