请教asp一次性插入多行insert into[问题
代码1card.asp 部分代码 ------------------
xx3=request.Form("textfield3")
xx4=request.Form("textfield4")
xx5=request.Form("textfield5")
xx6=request.Form("textfield6")
xx7=request.Form("textfield7")
xx8=request.Form("textfield8")
xx9=request.Form("textfield9")
xx10=request.Form("textfield10")
xx11=request.Form("textfield11")
xx12=request.Form("textfield12")
----------------------
conn.execute "insert into print_card(card) values('"&xx3&"')"
conn.execute "insert into print_card(card) values('"&xx4&"')"
conn.execute "insert into print_card(card) values('"&xx5&"')"
conn.execute "insert into print_card(card) values('"&xx6&"')"
conn.execute "insert into print_card(card) values('"&xx7&"')"
conn.execute "insert into print_card(card) values('"&xx8&"')"
conn.execute "insert into print_card(card) values('"&xx9&"')"
conn.execute "insert into print_card(card) values('"&xx10&"')"
conn.execute "insert into print_card(card) values('"&xx11&"')"
conn.execute "insert into print_card(card) values('"&xx12&"')"
------------------------
1.htm代码
<form id="form1" name="form1" method="post" action="1card.asp">
<table width="100%" height="92" border="0" align="center">
<tr>
<td width="163"> </td>
<td width="34">信箱 <br>
</td>
<td width="976">
<input type="text" name="textfield3" id="textfield3" />
<input type="text" name="textfield4" id="textfield4" />
<input type="text" name="textfield5" id="textfield5" />
<input type="text" name="textfield6" id="textfield6" />
<input type="text" name="textfield7" id="textfield7" />
<br>
<input type="text" name="textfield8" id="textfield8" />
<input type="text" name="textfield9" id="textfield9" />
<input type="text" name="textfield10" id="textfield10" />
<input type="text" name="textfield11" id="textfield11" />
<input type="text" name="textfield12" id="textfield12" />
活动信箱 </td>
<td width="68"> </td>
</tr>
<tr>
<td width="163"> </td>
<td colspan="2"> <label>
<input type="submit" name="button" id="button" value="生成" />
</label> </td>
<td width="68"> </td>
</tr>
</table>
</form>
我想实现 逗号分隔,只在一个框内一次性更新NN个信箱以上该怎么改写代码呢
例如 1@,223@,3123@,4213@,5123@,623@