问题描述：
<%if Request.QueryString("no")="edit" then
id=request.Form("id")
hx=request.form("hx")
hx2=request.form("hx2")
shu=request.form("shu")
rq=request.form("rq")
xm=request.form("xm")
xb=request.form("xb")
phone=request.form("phone")
email=request.form("email")
dz=request.form("dz")
content=request.form("content")
If hx="" Then
response.write "SORRY <br>"
response.write "请输入起始地点!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
If hx2="" Then
response.write "SORRY <br>"
response.write "请输入到达地点!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from book where id="&id
rs.open sql,conn,1,3
rs("hx")=hx
rs("hx2")=hx2
rs("xm")=xm
rs("xb")=xb
rs("phone")=phone
rs("email")=email
rs("dz")=dz
rs("content")=content
rs.update
rs.close
response.redirect "Manage_book.asp"
end if
%>
<form method="post" name="myform" action="Manage_editbook.asp?no=edit">
问题解答：
你先看看你的id值传过来了吗，
sql="select * from book where id="&id
输出一下这个查询，看看句子完整吗
很简单，你没有包含数据库连接文件
我靠,你们楼上垃圾,这样改:
<%if Request.QueryString("no")="edit" then
id=request.Form("id")
hx=request.form("hx")
hx2=request.form("hx2")
shu=request.form("shu")
rq=request.form("rq")
xm=request.form("xm")
xb=request.form("xb")
phone=request.form("phone")
email=request.form("email")
dz=request.form("dz")
content=request.form("content")
If hx="" Then
response.write "SORRY <br>"
response.write "请输入起始地点!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
If hx2="" Then
response.write "SORRY <br>"
response.write "请输入到达地点!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from book where id="&id
rs.open sql,conn,1,3
rs.addnew //这里加了一个添加
rs("hx")=hx
rs("hx2")=hx2
rs("xm")=xm
rs("xb")=xb
rs("phone")=phone
rs("email")=email
rs("dz")=dz
rs("content")=content
rs.update
rs.close
response.redirect "Manage_book.asp"
end if
%>
<form method="post" name="myform" action="Manage_editbook.asp?no=edit">
上海旅游网