ASP问题 问下

来源:百度知道 编辑:UC知道 时间:2024/06/14 11:32:23
请大家看下 这样错了么?
我使用这样提交数据 显示了成功
但是数据没有提交到数据库

<!--#include file="conn.asp"-->
<!--#include file="chklogin.asp"-->

<%
UserName2 = Request ("UserName")
Email = Request ("Email")
QQMSN = Request ("QQMSN")
Address = Request ("Address")
City = Request ("City")
State = Request ("State")
ZipCode = Request ("ZipCode")
PaymentMethod = Request ("PaymentMethod")
PaymentAccount = Request ("PaymentAccount")
Vacation = Request ("Vacation")
If Vacation = "" Then
Vacation = False
Else
Vacation = True
End if
If UserName <> UserName2 Then
Conn.Close
Session ("Message") = "产生未知错误,请再试一次。"
Response.Redirect "error.asp"
End if
rs.Open &qu

正确的是应该是

<%
UserName2 = Request("UserName")
Email = Request ("Email")
QQMSN = Request ("QQMSN")
Address = Request ("Address")
City = Request ("City")
State = Request ("State")
ZipCode = Request ("ZipCode")
PaymentMethod = Request ("PaymentMethod")
PaymentAccount = Request ("PaymentAccount")
Vacation = Request ("Vacation")

If Vacation = "" Then
Vacation = False
Else
Vacation = True
End if

If UserName <> UserName2 Then
Conn.Close:set Conn=nothing
Session ("Message") = "产生未知错误,请再试一次。"
Response.Redirect "error.asp"
else

Conn.execute("Update member Set Email = '" & Email & "', QQMSN = '" & QQMSN & "', Address = '" & Address & "', Cit