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

这个问题怎么解决啊?高手帮忙!

hinone 发布于 2010-08-10 19:21, 287 次点击
<table width="94%" border="0" align="right" cellpadding="0" cellspacing="0">
                <tr>
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="select  * from kh "
rs.open sql,conn,1,1
if rs.eof then%>
                  
    <tr>
                              <td height="8" align="center"><strong>暂无客户信息!</strong></td>
                            </tr>
                            <%else
do while not rs.eof
%>
                            <tr>
                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
                              </td>
                            <td>
                            <%     
rs.movenext
loop
rs.close
set rs=nothing
end if%>
</td>                  
</tr>                  
               
              </table>

这是我现在的写法!
现在显示的是
A
A
A
A
A
A
A
A
这样的,我想让他显示成
A A
A A
A A
A A
就是一个TABLE里,现在显示的是一列,我想让他变成,达到20条后,自动变成2列!高手帮忙啊,救命啊!
2 回复
#2
zmh8862010-08-10 20:46

                            <td>
                            <%     
rs.movenext
改成

                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
                              </td>
                            <%     
rs.movenext

</td>                  
</tr>   
改为

         
</tr>   
#3
hams2010-08-10 21:46
<table width="94%" border="0" align="right" cellpadding="0" cellspacing="0">
                <tr>
                <%
set rs=server.CreateObject("adodb.Recordset")
sql="select  * from kh "
rs.open sql,conn,1,1
if rs.eof then%>
                  
    <tr>
                              <td height="8" align="center"><strong>暂无客户信息!</strong></td>
                            </tr>
                            <%else
do while not rs.eof
%>
                            <tr>
                              <td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
                              </td>
<%
rs.movenext
if rs.eof then
%>
<td height="22"></td>
<%else%>
<td height="22"><img height="5" src="image/icon_dot01.gif" width="5">
                                <%if len(rs("name")) > 100 then Response.write left(rs("nema"),100)&"..." else Response.write rs("name") end if%>
                              </td>
<%   
rs.movenext
end if
%>
                            <td>
                            <% loop
rs.close
set rs=nothing
end if%>
</td>                  
</tr>                  
               
              </table>
1