如何提交保存多条记录

[会织网的蚂蚁]

如何提交保存多条记录

[cncfish]

rs.update

[leelong80]

up

[hgxlucky]

split

[clon]

楼主说的很不清楚哦

一般情况下你只需做循环一条条保存就行了

[wxcyz]

for i=1 to 20
xinghao=Trim(request("T1_"&i))
changjia=Trim(request("T2_"&i))
shuliang=Trim(request("T3_"&i))
pihao=Trim(request("T4_"))
fengzhuang=Trim(request("T5_"&i))
danjia=Trim(request("T6_"&i))
gonghuo=Trim(request("T7_"&i))
beizhu1=Trim(request("T8_"&i))
tel1=Trim(request("T9_"&i))
tel2=Trim(request("T10_"&i))
lishi=Trim(request("T11_"&i))
xundate=Trim(request("T12_"&i))
xunjia=Trim(request("T13_"&i))
beizhu2=Trim(request("T14_"&i))

if xinghao<>"" then
conn.execute "insert into pfdzdate (xinghao,changjia,shuliang,pihao,fengzhuang,danjia,gonghuo,beizhu1,tel1,tel2,lishi,xundate,xunjia,beizhu2) values ('"&xinghao&"','"&changjia&"','"&shuliang&"','"&pihao&"','"&fengzhuang&"','"&danjia&"','"&gonghuo&"','"&beizhu1&"','"&tel1&"','"&tel2&"','"&lishi&"','"&xundate&"','"&xunjia&"','"&beizhu2&"')"
end if
next
response.write "<script language=javascript>alert('数据添加成功，返回中...');</script>"
response.write "<script language=javascript>this.location.href='admin_client.asp';</script>"