<%
if request.form("title3")="" then
response.write "错误提示:请输入电影名称!"
response.end
end if
if request.form("typeid")="影片类型" then
response.write "错误提示:请输入电影类型!"
response.end
end if
if request.form("where")="出产地区" then
response.write "错误提示:请输入电影出产地区!"
response.end
end if
if request.form("movietype")="" then
response.write "错误提示:请输入电影类型!"
response.end
end if
if request.form("softlevel")="选择推荐度" then
response.write "错误提示:请输入电影推荐度!"
response.end
end if
if request.form("name")="" then
response.write "错误提示:请输入电影领衔主演!"
response.end
end if
if request.form("content3")="" then
response.write "错误提示:请输入电影简介!"
response.end
end if
%>
<%
title=request.form("title3")
no=request.form("no")
set rs=server.createobject("adodb.recordset")
sql="select * from learning where (articleid is null)"
rs.open sql,conn,1,3
rs.addnew
rs("serverip")=request.form("serverip")
rs("typeid")=Request.Form("typeid")
rs("softlevel")=Request.Form("softlevel")
rs("where")=Request.Form("where")
rs("title")=title
rs("content")=replace(request.form("content3"),vbcrlf,"<br>")
rs("dateandtime")=date()
rs("onlinelook")=request.form("onlinelookb")
rs("down")=request.form("downv")
rs("canlook")=request.form("canlook")
rs("howlong")=request.form("howlong4")
rs("url")=request.form("url")
rs("best")=request.form("best")
rs("domurl")=request.form("domurl3")
rs("hits")=request.form("hits")
rs("name")=request.form("name")
rs("count")=request.form("count")
rs("movietype")=request.form("movietype")
rs.update
articleid=rs("articleid")
rs.close
set rs=server.createobject("adodb.recordset")
sql1="select * from movieurl where (id is null)"
rs.open sql1,conn,1,3
for i=1 to no
rs.addnew
url=trim(request.form("urla"&i&""))
rs("nameid")=articleid
rs("url")=url
rs.update
next
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
帮我看一下怎么rs("nameid")=articleid代码没法执行。这是两个表的字段是让第一个表的articleid内容传到第二个表的nameid里。
