28,391
社区成员
发帖
与我相关
我的任务
分享
for i=0 to Request.Form("a").count
rs.addnew
rs("a") = Request.Form("a")(i)
rs("b") = Request.Form("b")(i)
rs("c") = Request.Form("c")(i)
rs.update
rs.movenext
next
for i=0 to UBound(a)
rs.addnew
rs("a") = a(i)
rs("b") = b(i)
if i<=ubound(c) then
rs("c") = c(i)
else
rs("c") = ""
end
rs.update
rs.movenext
next
<head>
<title>test</title></head>
<body>
<form name="form1" method="post" action="test.asp?action=add">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>A</td>
<td>B</td>
<td>C</td>
</tr>
<tr>
<td><input type="text" name="a" id="a"></td>
<td><input type="text" name="b" id="b"></td>
<td><input type="text" name="c" id="c"></td>
</tr>
<tr>
<td><input type="text" name="a" id="a"></td>
<td><input type="text" name="b" id="b"></td>
<td><input type="text" name="c" id="c"></td>
</tr>
<tr>
<td><input type="text" name="a" id="a"></td>
<td><input type="text" name="b" id="b"></td>
<td><input type="text" name="c" id="c"></td>
</tr>
<tr>
<td><input type="text" name="a" id="a"></td>
<td><input type="text" name="b" id="b"></td>
<td><input type="text" name="c" id="c"></td>
</tr>
<tr>
<td><input type="text" name="a" id="a"></td>
<td><input type="text" name="b" id="b"></td>
<td><input type="text" name="c" id="c"></td>
</tr>
</table>
<input type="submit" name="button" id="button" value="提交">
</form>
</body>
</html>
test.asp
<%
Dim a
Dim b
Dim c
Dim action
action = Request.QueryString("action")
a = Trim(Request.Form("a"))
b = Trim(Request.Form("b"))
c = Trim(Request.Form("c"))
'把字符串中有空值的去掉
a = replace(replace(a," ",""),",,","")
b = replace(replace(b," ",""),",,","")
c = replace(replace(c," ",""),",,","")
select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * FROM test ",conn,1,3
a = Split(a,",")
b = Split(b,",")
c = Split(c,",")
for i=0 to UBound(a)
rs.addnew
rs("a") = a
rs("b") = b
rs("c") = c
rs.update
rs.movenext
next
response.Write "<script language='javascript'>alert('添加成功');</script>"
rs.close
set rs=nothing
end select
conn.close
set conn=nothing
%>
slwsss,你好,具体代码如上:
网页中每行有3个文本框:a,b,c,一共5行。
其中a,b是必填项目,c不是必填,比如
填写了2行a,就肯定有2行b,c有可能没有,也有可能有1行,也有可能2行。同样
填写了5行a,就肯定有5行b,c有可能没有,也有可能有1行,也有可能2行。
插入的循环行数参考a,现在就是当c跟a,b等长的时候,插入正常,当c和a,b长度不同的时候,就提示“下标越界”
(还有一个问题,文本框post过来的字符串,为什么都是"A, B, C, , ,"这样的格式,每个字符串前面都有一个空格,而不是"A,B,C,,,",所以没办法,在接收的时候用replace过滤了2次才正常)