asp+js做的动态添加数据行,为何数据表会自动多添加一空白行
狐猫 2017-06-01 10:18:34 前台代码:
<table width="99%" border="0" id="tabUserInfo" cellpadding="0" cellspacing="1">
<tr class="bb02" align="center">
<td>件数:</td>
<td>单件重量</td>
<td>总重量</td>
<td>操作</td>
</tr>
<tr style="display:none" id="trUserInfo" align="center" bgcolor="#FFFFFF">
<td id="tdUserInfo" bgcolor="#FFFFFF"><input id="dhsl" name="dhsl" value="<%=dhsl%>" type="text"></td>
<td id="tdUserInfo" bgcolor="#FFFFFF"><input id="dhck" name="dhck" value="<%=dhck%>" type="text"></td>
<td id="tdUserInfo" bgcolor="#FFFFFF"><input id="xlh" name="xlh" value="<%=xlh%>" type="text"></td>
<td id="tdUserInfo" bgcolor="#FFFFFF"><input type="button" value="删除" onclick="deleteRow(document.all.tabUserInfo,1,this)"></td>
</tr>
<tr><td id="tdUserInfo"><input type="button" value="新增" onclick="addRow(document.all.tabUserInfo,null,1,1)" class="submit1"></td></tr>
</table>
后台代码:
'------------------------------添加和修改信息部分--------------------------------------
moduleid=0
if request("moduleid")<>"" then
moduleid=cint(request("moduleid"))
end if
conn.beginTrans ' Start a transaction
sql = "insert into rc_qt(sbmc,txm) values('"& request("sbmc") &"','"& request("txm") &"')"
conn.execute(sql)
if request("dhsl").count>0 then
dim maxid
maxid = 1
sql = "select max(qtid) as maxid from rc_qt"
set rs = conn.execute(sql)
maxid = rs("maxid")
rs.close
set rs = nothing
for i =1 to request("dhsl").count
sql = "insert into rc_qtt(qtid,dhsl,dhck,xlh) values("& maxid &",'"& request("dhsl")(i) &"','"& request("dhck")(i) &"','"& request("xlh")(i) &"')"
conn.execute(sql)
next
end if
以上代码就是点击保存后sql数据表会自动多增加了一行,但我明明只增加两行,现在变成三行,求高手们指教