Question

asp中修改ID为1的内容,请问以下内容哪里有问题?

表:live
字段: ID add
1 http
显示页: <input type="text" name="add" value="<%=rslive("add")%>">
<input name="ID" type="hidden" value="<%=rslive("ID")%>">
//此内容能显示 提交无误

<%
Set rslive = Server.CreateObject("ADODB.Recordset")
sql = "update live set address = '"&Trim(Request.Form("address"))&"' where ID= "&Trim(Request.Form("ID"))
con.execute sql
response.write "<script language='javascript'>"
response.write "alert('修改成功');"
response.write "location.href='default.asp';"
response.write "</script>"
response.end
%>
if Trim(Request.Form("address"))<>"" then
sql = "update live set address = '"&Trim(Request.Form("address"))&"' where ID= "&Trim(Request.Form("ID"))
con.execute(sql)
response.write "<script language='javascript'>"
response.write "alert('修改成功');"
response.write "location.href='default.asp';"
response.write "</script>"
response.end
end if

//提交跳转了,没有修改内容........

Answer 1

你要学会测试，先看看那两个值能不能传过去，如果传过去了，那就是你提交代码有问题，这样说，你知道如果在遇到类似问题，知道怎么解了吧？

Answer 2

如果找不到错误,建议使用排错法,改成
set rs=server.xxxxxx
rs.open "select * from live where id=xxxx",conn,1,3
rs("address")=Request.form("address")
rs.update
如果这样还不行,请检查你的数据库权限!