纳米微吸材料:一段修改个人信息的ASP代码,请大侠指点。谢谢谢谢

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/27 18:56:53
<!--#include file="conn.asp"-->
<%
User2 = Request ("User")
Email = Request ("Email")
QQMSN = Request ("QQMSN")
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 "Update member Set Email = '" & Email & "', QQMSN = '" & QQMSN & "', Vacation = '" & Vacation & "' Where User = '" & User & "'",Conn
Conn.Close
Session ("Message") = "个人信息修改成功。<a href=user.asp>返回<?a>"
Response.Redirect "succ.asp"
%>
用户名不能修改。
Vacation是个选项,是或否
现在的问题是提交修改时显示错误,而修改第二段IF语句后,提示修改成功,但是却无法加入数据库内信息,显示的还是原信息。谢谢谢谢
Set Conn = nothing
Session ("Message") = "个人信息修改成功。<a href='user.asp'>返回</a>"
Response.Redirect "succ.asp"
Response.End
最后语句也用过这个,没有用。菜的很,请指点一下。不胜感激。。谢谢
感谢楼下两位的热心回答,不行的,没有解决问题
If UserName <> UserName2 Then
这行代码应该是If User <> User2 Then

1、Vacation 左右不需要加 ' 符号
2、rs.Open的第三、四个参数有问题。第四个参数不写的话默认是adLockReadOnly(只读,无法修改)

试试下面代码,看问题是否能解决:

rs.Open "Update member Set Email = '" & Email & "', QQMSN = '" & QQMSN & "', Vacation = " & Vacation & " Where User = '" & User & "'",Conn ,1,3

是不是你用了关键字呢,我记得user好像就是,试一下吧

引用
----------------
rs.Open "Update member Set Email = '" & Email & "', QQMSN = '" & QQMSN & "', Vacation = '" & Vacation & "' Where User = '" & User & "'",Conn
----------------------
最讨厌这种长的表达式!!!!!超级BS
写成这样:
set rs=server.creatobject("adodb.recordset")
sql="select * from member where user="&user
rs.open sql,conn,1,3 '这里1,3代表可写;1,1代表只读!
rs("email")=email
rs("qqmsn")=qqmsn
rs("vacation")=vacation
rs.update
set rs=nothing
------------------------
这样又明白,又清楚!
如果还不行,把原文件和错误描述我发到邮箱!!
mrtuzicn@yahoo.com.cn