实现功能是:用户注册的时候把用户信息存到用户表people,people有主键user_id(自增类型),如何把这个主键同时保存到用户的工作经历表(work)中
insert into work (UserID) values (select user_id from people)
这是我的代码,运行之后显:rs1.open str1,conn,3,1
示参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
用户表people信息增加,但是另外一个表没有成功把user_id值插进去
<%
name=trim(request.form("name"))
if len(name)< 2 then
response.write "<br><br><center>"
response.write "请输入2个字符以上的用户名!"
response.write "</center>"
response.end
end if
if Instr(name,"FileBZ")> 0 or Instr(bbsuser,"<!--")>0 or Instr(name,"-->")>0 or Instr(name,"=")>0 or Instr(name,"%")>0 or Instr(name,chr(32))>0 or Instr(name,"?")>0 or Instr(bbsuser,"&")>0 or Instr(name,";")>0 or Instr(name,",")>0 or Instr(name,"'")>0 or Instr(name,",")>0 or Instr(name,chr(34))>0 or Instr(name,chr(9))>0 or Instr(name,"")>0 or Instr(name,chr(1))>0 then
response.write "<br><br><center>"
response.write "名字中含有非法字符,请重新输入!"
response.write "</center>"
response.end
end if
pwd=request.form("pwd")
name=trim(request.form("name"))
if Instr(name,"FileBZ")> 0 or Instr(name,"<!--")>0 or Instr(name,"-->")>0 or Instr(name,"=")>0 or Instr(name,"%")>0 or Instr(name,chr(32))>0 or Instr(name,"?")>0 or Instr(name,"&")>0 or Instr(name,";")>0 or Instr(name,",")>0 or Instr(name,"'")>0 or Instr(name,",")>0 or Instr(name,chr(34))>0 or Instr(name,chr(9))>0 or Instr(name,"")>0 or Instr(name,chr(1))>0 then
response.write "<br><br><center>"
response.write "用户名中含有非法字符,请重新输入!"
response.write "</center>"
response.end
end if
pwd=request.form("pwd")
pwd=request.form("pwd")
str="select * from people where name='"&name&"'"
set rs=server.createobject("adodb.recordset")
rs.open str,conn,3,1
if not rs.eof then
response.write "<script language='javascript'>"
response.write "alert('该用户已经有人使用,请重新注册!');"
response.write "history.go(-1);"
response.write "</script>"
response.end
'msg="该用户已经有人使用,请重新注册!"
'sign=0
else
sql="select * from people where (user_id is null)"
set rsr=server.createobject("adodb.recordset")
rsr.open sql,conn,1,3
rsr.addnew
rsr("name")=name
rsr("shenfenID")=trim(request.form("shenfenID"))
rsr("pwd")=trim(request.form("pwd"))
rsr("sex")=trim(request.form("sex"))
rsr("question")=trim(request.form("question"))
rsr("email")=trim(request.form("email"))
rsr("answer")=trim(request.form("answer"))
'rsr("ip")=request.servervariables("remote_addr")'ip地址
rsr.update
srt1="insert into famdetail(user_id) values (select user_id from people where name='"&name&"')"
set rs1=server.createobject("adodb.recordset")
rs1.open str1,conn,3,1
或者直接,conn.execute(sql)