补充一下,在循环添加的时候.用上事务.
tempStr=request("returnValue")
if tempStr<>"" then
ar = split(tempStr,",")
conn.BeginTrans
for i=0 to ubound(ar)
sql = "insert into table values('" + ar(i) + "')"
conn.execute(sql)
next
end if
if conn.errors.count>0 then
conn.RollBackTrans
CloseConn
response.write "数据操作失败"
response.end
else
conn.CommitTrans
CloseConn
response.write "数据操作成功"
end if