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

请教asp一次性插入多行insert into[问题

chjyyyy 发布于 2009-07-20 03:31, 1347 次点击
代码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">&nbsp; </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">&nbsp; </td>
    </tr>
    <tr>
      <td width="163">&nbsp; </td>
      <td colspan="2"> <label>   
        <input type="submit" name="button" id="button" value="生成" />
        </label> </td>
      <td width="68">&nbsp; </td>
    </tr>
  </table>

</form>


我想实现 逗号分隔,只在一个框内一次性更新NN个信箱以上该怎么改写代码呢
例如 1@,223@,3123@,4213@,5123@,623@
3 回复
#2
sunfishy2009-07-20 08:45
用FOR循环执行conn.execute吧.

也省的写那么多.!
#3
flynet2009-07-20 13:11
ls 正解
#4
yms1232009-07-20 13:53
代码1card.asp 部分代码

Dim i,tmpMail
For i=0 To request.From("MailTxt").Count
    tmpMail=request.From("MailTxt")(i)
    conn.execute("insert into print_card(card) values('"&tmpMail&"')")
Next

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="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <br>
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        <input type="text" name="MailTxt"  />
        活动信箱 </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>
用循环两三行就能完成10多行代码的功能,为什么不用呢?
1