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

菜鸟请教:最新产品调用问题

baiyun88 发布于 2009-11-24 11:07, 466 次点击
程序代码:
<%
                                                     
          StrSQL="select top 20 * from products where Recommend='1' order By PubDate desc"
         oConnRs.Open StrSQL,oConn,1,1
         lCnt= oConnRs.RecordCount

              Response.Write"<DIV id=demo7 style='OVERFLOW: hidden; WIDTH: 671px; COLOR: #ffffff'><table border='0' cellpadding='0' >"
              Response.Write "<tr valign='top'>"
              Response.Write "<td id=demo3 valign='top' ><table  border='0' cellspacing='3'><tr valign='top'>"

          while not oConnRs.eof
          Response.Write "<td width='120' valign='top' >"
         
         
Response.Write "      <table width=""160"" border=""0"" cellpadding=""0"" cellspacing=""0"" class='unnamed2'>"
Response.Write "      <tr>"
Response.Write "        <td height=""90"" align=""center"" valign=""bottom"" >"
Response.Write "<table width='120' height='100' border='0' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC' class='unnamed1'><tr><td align='center' valign='middle' bgcolor='#FFFFFF'>"
      
Response.Write "<a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" ><img width='150' height='113' id=ht"&oConnRs("id")&"  src='"&ImgURL(oConnRs("ImgSrc2"))&"'  border=0 ></a>"
Response.Write "</td></tr></table></td>"
Response.Write "      </tr>"
Response.Write "      <tr>"
Response.Write "        <td height=""20"" align=""center"" valign=""middle""><a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" class=""t2"" >"&oConnRs("ProduceID")&"</a></td>"
Response.Write "      </tr> <tr><td height=""20""  align=""center"" valign=""middle""><a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" class=""t2"" >"&oConnRs("name")&"</a></td></tr>"
Response.Write "    </table>"


Response.Write "</td>"

            

              oConnRs.movenext
            
          wend
          Response.Write "</tr></table></td><td id=demo4 valign='top' ></td></tr>"
          Response.Write "</table></div>"

          oConnRs.Close
          %>
这个首页最新产品调用的代码,显示是一行的,如果把他改成 一列 4个产品  分5行呢?希望告诉指点一下,谢谢。
1 回复
#2
孤独冷雨2009-11-24 14:17
<%
                                                     
          StrSQL="select top 20 * from products where Recommend='1' order By PubDate desc"
         oConnRs.Open StrSQL,oConn,1,1
         if not oConnRs.eof then
        

              Response.Write"<DIV id=demo7 style='OVERFLOW: hidden; WIDTH: 671px; COLOR: #ffffff'><table border='0' cellpadding='0' >"
              Response.Write "<tr valign='top'>"
              Response.Write "<td id=demo3 valign='top' ><table  border='0' cellspacing='3'>"
                  j=1
              Response.Write "<tr valign='top'>"
                  for i=1 to 20
          Response.Write "<td width='120' valign='top' >"
         
         
Response.Write "      <table width=""160"" border=""0"" cellpadding=""0"" cellspacing=""0"" class='unnamed2'>"
Response.Write "      <tr>"
Response.Write "        <td height=""90"" align=""center"" valign=""bottom"" >"
Response.Write "<table width='120' height='100' border='0' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC' class='unnamed1'><tr><td align='center' valign='middle' bgcolor='#FFFFFF'>"
      
Response.Write "<a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" ><img width='150' height='113' id=ht"&oConnRs("id")&"  src='"&ImgURL(oConnRs("ImgSrc2"))&"'  border=0 ></a>"
Response.Write "</td></tr></table></td>"
Response.Write "      </tr>"
Response.Write "      <tr>"
Response.Write "        <td height=""20"" align=""center"" valign=""middle""><a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" class=""t2"" >"&oConnRs("ProduceID")&"</a></td>"
Response.Write "      </tr> <tr><td height=""20""  align=""center"" valign=""middle""><a href=show.asp?id=" &oConnRs("ID")& " target=""_blank"" class=""t2"" >"&oConnRs("name")&"</a></td></tr>"
Response.Write "    </table>"


Response.Write "</td>"

            

                              if (j mod 4)=0 then
                              response.Write "</tr><tr>"
                                end if
                                j= j + 1
                                oConnRs.movenext
                                if oConnRs.eof then exit for
                                next
                           
            
        
          Response.Write "</tr></table></td><td id=demo4 valign='top' ></td></tr>"
                        
        end if
                           
          Response.Write "</table></div>"

          oConnRs.Close
          %>
  
1