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

求救怎么读出是2列显示

copy462829 发布于 2008-03-18 10:55, 632 次点击
<table width="540" border="0">
                              
                              
                                  <%  


    set rsty=server.CreateObject("adodb.recordset")
        sqlty="select * from teacherInfo "
        'response.Write sqlty
        'response.end
        rsty.open sqlty,conn,3,1
        
        if not rsty.eof then
           for ii=0 to rsty.recordcount-1
       
           %>
    
  <tr >
    <td width="270"><a href="teacherInfo.asp?classid=<%=rsty("ID")%>"><img src="<%=rsty("imgurl")%>"/ width="270" height="203" border="0"></a>
   
    </td>
   
 
  </tr>
  <tr>
  <td>
  <%=rsty("caption")%>
  </td>
  </tr>
         
         
         
                <%
                        
                 rsty.movenext
              if rsty.eof then exit for
           next        
        end if
    
    rsty.close
    set rsty=Nothing
    

    %>
              
</table>

这样只读出 1列显示 怎么读出显示2列的
2 回复
#2
madpbpl2008-03-18 12:30
<tr>
 <td width="270"><a href="teacherInfo.asp?classid=<%=rsty("ID")%>"><img src="<%=rsty("imgurl")%>"/ width="270" height="203" border="0"></a>
 </td>
 <td>
  <%=rsty("caption")%>
 </td>
</tr>
#3
gdk20062008-03-18 13:15
在“for ii=0 to rsty.recordcount-1”之前加个rsty.MoveNext
1