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

循环显示问题

fkueyga6 发布于 2013-05-23 10:40, 668 次点击
表 gz
id     name         je
1      张三     100,200,50
2      李四     200,150,100

循环gz
.............
.................................合计
张三    100      200     50      350
李四    200      150     100     450
.............
这种循环显示怎么弄?
4 回复
#2
hu9jj2013-05-23 17:15
数据表结构设计的不合理,这样处理起来很麻烦的。
#3
fkueyga62013-05-24 09:24
自己解决了:
<%for ii=1 to rs.recordcount
if rs.eof then exit for
t2=replace(rs("je")," ","")
t2=split(t2,",")
s=0
%>
                <tr class="STYLE2">
                  <td height="40" align="center" class="biankuan2"><input name="name" type="text" class="wenbenkuan-name" id="name" value="<%=rs("name")%>" size="10" readonly="true" /></td>
                  <td class="biankuan10">
                  <table width="<%=70*UBound(t1)%>" border="0" cellpadding="0" cellspacing="0">
                      <tr class="STYLE2">
                      <%for iii=0 to UBound(t2)
                      s=s+t2(iii)
                      %>
                         <td width="70" class="biankuan15" align="center" height="40"><input name="je<%=rs("id")%>" id="je<%=rs("id")%>" type="text" class="wenbenkuan-je" value="<%=t2(iii)%>" onblur="value=value.replace(/[^0-9.]/g,'0');" /></td>
                      <%next%>
                      </tr>
                    </table>
                  </td>
                  <td width="70" class="biankuan10"><input name="hj" type="text" class="wenbenkuan-je" id="hj" value="<%=s%>" size="10" readonly="true" /><input name="id" type="hidden" id="id" value="<%=rs("id")%>" /></td>
                </tr>
<%
rs.movenext
next%>
#4
fkueyga62013-05-24 10:50
但是这个必须提交到数据库后才能有效,请问JS如果将je的合计显示到hj里?
#5
fkueyga62013-05-24 10:53
<input name="hj" type="text" class="wenbenkuan-je" id="hj" value="<%=s%>" size="10" readonly="true" />
应该为
<input name="hj<%=rs("id")%>" type="text" class="wenbenkuan-je" id="hj<%=rs("id")%>" value="<%=s%>" size="10" readonly="true" />
1