帮忙看一下吧：）

[wzq8848]

id = request.QueryString("id")
username=request.form("username")
nickname=request.form("nickname")
name=request.form("name")
password=request.form("password")
protect_question=request.form("protect_question")
protect_answer=request.form("protect_answer")
id_card_num=request.form("id_card_num")
telephone=request.form("telephone")
email=request.form("email")
zip_code=request.form("zip_code")
address=request.form("address")



update = "update HanagaMemberTempTable set username=username,nickname=nickname,name=name,password=password,protect_question=protect_question,protect_answer=protect_answer,id_card_num=id_card_num,telephone=telephone,email=email,zip_code=zip_code,address=address where id='" & id & "'"
conn.Execute update

response.redirect("list.asp")

修改以后没反应，也不提示出错。。。。。

[lazywolf]

同意wybm()
你按他的程序试试！

[wzq8848]

怎么试阿？

[gq]

sql语句：update 没有达到你的要求。
改为：
update = "update HanagaMemberTempTable set username= "&username &",nickname=" &"nickname" &",name=" &"name" &",password=" &"password" &",protect_question=" &"protect_question" &",protect_answer=" &"protect_answer" &",id_card_num=" &"id_card_num" &",telephone=" &"telephone" &",email=" &"email" &",zip_code=" &"zip_code" &",address=" &"address" &" where id='" & id & "'"

注意：我把每个变量当成了整型。字符型要修改。

[gq]

sorry.
变量前的"号不要。。呵呵。加多了。。

[www525]

楼上的我支持

[wzq8848]

还是不行哦 ，同样的方法 如果先delete在用insert 就行...... 晕

[wybm]

id = request.QueryString("id")
username=request.form("username")
username=replace(username,"'","''")
nickname=request.form("nickname")
nickname=replace(nickname,"'","''")
name=request.form("name")
name=replace(name,"'","''")
password=request.form("password")
protect_question=request.form("protect_question")
protect_question=replace(protect_question,"'","''")
protect_answer=request.form("protect_answer")
protect_answer=replace(protect_answer,"'","''")
id_card_num=request.form("id_card_num")
telephone=request.form("telephone")
email=request.form("email")
email=replace(email,"'","''")
zip_code=request.form("zip_code")
address=request.form("address")
address=replace(address,"'","''")
update = "update HanagaMemberTempTable set username='"&username &"',nickname='" &nickname&"',name='" &name&"',password="&password &",protect_question='" &protect_question&"',protect_answer='" &protect_answer&"',id_card_num="&id_card_num&",telephone=" &telephone&",email='" &email &"',zip_code=" &"zip_code" &",address='"&address &"' where id=" & id


response.redirect("list.asp")

[gq]

你将sql语句：update打印出来看看有没有错。。
最好放到sql server运行一下看看有没有错。。
可以知道是sql语句的错。。还是asp的错。

[www525]

好想Sql是有这毛病，上面那个应该是可以的

[wzq8848]

在sql语后面用response.Write 可以写出所有字段 数据库和表名也没错....应该是sql语句的问题？

[wzq8848]

帮帮忙阿