为什么我这个页面插入不了数据?
来源:百度知道 编辑: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
<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呢?没有更新当然不行了