为什么我这个页面插入不了数据?

来源:百度知道 编辑:UC知道 时间:2024/04/27 18:43:20
<!--#include file="conn.asp"-->

<head>

<title>注册处理页面</title>

</head>

<body>
<%
Dim rs,mySQL
dim UserID,UserName,UserPass,NiCheng,Sex,ZhiYe,AiHao,JieShao,Pro,City
Set rs=Server.CreateObject ("ADODB.Connection")
rs.open

UserID=request.form("login")
UserName=request.form("realname")
UserPass=request.form("passwd")
Pro=request.form("state")
City=request.form("city")
Sex=request.form("gender")
NiCheng=request.form("NiCheng")
ZhiYe=request.form("ZhiYe")
JieShao=request.form("JieShao")
AiHao=request.form("AiHao")

mySQL="select * from user where UserID='" & UserID & "'"
set myRes=rs.execute(mySQL)

if myRes.bof and myRes.eof then

mySQL2=&q

mySQL2="insert into user (UserID,UserName,UserPass,NiCheng,Sex,ZhiYe,AiHao,JieShao,Pro,City) values('" &UserID& "','" &UserName& "','"&UserPass&"','"&NiCheng&"','"&Sex&"','"&ZhiYe&"','"&AiHao&"','"&JieShao&"','"&Pro&"','"&City&"')"

SQL="insert into DD(name,SHUO)values('"+NAME+"','"+SHUO+"')"
&换成+试下

Updata呢?没有更新当然不行了