Question

ASP 修改记录时为什么只修改第一条记录啊

<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then

flyDate=request.form("flyDate")
juzhu=request.form("province")
gongzuodi=request.form("province1")

if request.form("survey_ms_time")<>"" then
d_shij=request.form("survey_ms_time")
else
d_shij=request.form("survey_ms_time_other")
end if

if request.form("survey_ns_time")<>"" then
w_shij=request.form("survey_ns_time")
else
w_shij=request.form("survey_ns_time_other")
end if

if request.form("survey_away")<>"" then
xcfangs=request.form("survey_away")
else
xcfangs=request.form("survey_away_other")
end if

m_name=request.form("m_name")
m_tel=request.form("m_tel")
m_email=request.form("m_email")
m_bei=request.form("m_bei")
fclx=request.form("fclx")
id=request.form("id")

dim rs,sql
id=request("id")&""
set rs=server.CreateObject("adodb.recordset")
qsql=" select * from tousu1 where id="&id&""
rs.open qsql,conn,1,3

rs("flyDate")=flyDate
rs("juzhu")=juzhu
rs("gongzuodi")=gongzuodi
rs("d_shij")=d_shij
rs("w_shij")=w_shij
rs("xcfangs")=xcfangs
rs("Rebate")=Rebate
rs("m_name")=m_name
rs("m_tel")=m_tel
rs("m_email")=m_email
rs("m_bei")=m_bei
rs("fclx")=fclx

rs.update
rs.close:set rs=nothing
response.write "<script>alert('回复成功!');location.href='tousu.asp"&other&"'</script>"
end if
%>
有多条记录但无论修改那条都是修改的第一条记录怎么回事呢？？

<Form Name="FrmAddDoc" Method="Post" action="huifusave.asp?action=rename&id=<%=("id")%>" OnSubmit="return ChkForm();">

Answer 1

qsql=" select * from tousu1 where id="&id&""这里的问题 定义了修改id=好多的数据 你把where id=?去掉就是修改全部 如果是范围修改 比如id>0<100 这样你就写成select * from tousu1 where id> and id<100

追问

没用啊·我是小白请详细说明并写出来，谢谢！