Question

ASP中调用间隔符写多个数据

urldx="4.9|||5.6|||3.5|||6.8|||289.7"
url="123|||456|||789|||012|||345"
urlname="vod1|||vod2|||vod3|||vod4|||vod5"
nameid="1"

用分隔符隔开的地址在写数据的时候能不能转成一行一个数据.
就是
ID nameid urldx urlname url
1 1 4.9 vod1 123
2 1 5.6 vod2 456
3 1 3.5 vod3 789
是写入数据库,不是要显示!!!

Answer 1

urldxArray=split(urldx,"|||")
urlArray=split(url,"|||")
urlnameArray=split(urlname,"|||")
for i=0 to Ubound(urlArray)
rs.close
set rs=nothing
sql="insert into 表 (nameid,urldx,urlname,url) values("&nameid&","&urldxArray(i)&","&urlnameArray(i)&","&urlArray(i)&")"
conn.Execute(sql)
next

至于你说的"ADODB.Connection 错误 '800a0e79' 对象打开时，不允许操作。"这个问题,可能是你的RS没有关闭,你可以在for与sql之间加上
rs.close
set rs=nothing

Answer 2

urldxs=split(urldx,"|||")
urls=split(url,"|||")
urlnames=split(urlname,"|||")
for i=0 to ubound(urldxs)
response.write cstr(i+1)+" "+nameid+" "+urldxs(i)+" "+urlnames(i)+" "+urls(i)+"<br>"
next