Question

asp 数组 循环插入到数据库 代码如图：

得到的是 数组 ，插入就报错了

Answer 1

sql语句不对吧？
insert into t_xuqiuzhusi (taskid,beizhu) values ('"&strtaskid&"','"&strbeizhu&"')

追问

输出SQL 如此 ，该如何改，求解答啊

追答

<%
beizhu=replace(trim(request.Form("beizhu")),"'","")
taskid=replace(trim(request.Form("taskid")),"'","")
beizhu=split(beizhu,",")
taskid=split(taskid,",")
for i=0 to ubound(beizhu)
conn.execute("insert into t_xuqiuzhusi (taskid,beizhu) values ('"&trim(beizhu(i))&"','"&trim(taskid(i))&"')")
next
%>