ASP中调用间隔符写多个数据
发布网友
发布时间:2022-05-19 04:55
我来回答
共2个回答
热心网友
时间:2024-03-04 15:32
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
热心网友
时间:2024-03-04 15:32
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