没人能帮小弟解决下吗?这样写到底有什么错误!为什么不能修改!有源程序!麻烦大家下回去看下!小弟感激!!
找到问题了!
原因有两个:
1.是表单设置的为 POST 方式,应采用 Request.Form(...) 获取而不是 Request(...) (等价于 Request.QueryString(...))
2.表单中没有 id 信息,所以修改的内容没有保存
saveaddnews1.asp:
<!--#include file="conn.asp"-->
<%
dim rs,sql
set rs=server.CreateObject("adodb.recordset")
sql="select * from article where art_id=" & request.form("id")
rs.open sql,conn,1,3
rs("shoug")=trim(request.form("shoug"))
rs("danhao")=trim(request.form("danhao"))
rs("time1")=trim(request.form("time1"))
rs("jinxiaos")=trim(request.form("jinxiaos"))
rs("jinxiaosdh")=trim(request.form("jinxiaosdh"))
rs("chuchao")=trim(request.form("chuchao"))
rs("typename")=trim(request.form("typename"))
rs("dianhua")=trim(request.form("dianhua"))
rs("textfield")=trim(request.form("textfield"))
rs("dianhua1")=trim(request.form("dianhua1"))
rs("didian")=trim(request.form("didian"))
rs("riqi")=trim(request.form("riqi"))
rs("dizhi")=trim(request.form("dizhi"))
rs("fapiaohao")=trim(request.form("fapiaohao"))
rs("youz")=trim(request.form("youz"))
rs("select2")=trim(request.form("select2"))
rs("sel")=trim(request.form("sel"))
rs("guzhang")=trim(request.form("guzhang"))
rs("yanse")=trim(request.form("yanse"))
rs("DPY")=trim(request.form("DPY"))
rs("ESM")=trim(request.form("ESM"))
rs("chuanhao")=trim(request.form("chuanhao"))
rs("fujian")=trim(request.form("fujian"))
rs("xuhao")=trim(request.form("xuhao"))
rs("select3")=trim(request.form("select3"))
rs("cishu")=trim(request.form("cishu"))
rs("xinzi")=trim(request.form("xinzi"))
rs("baojia")=trim(request.form("baojia"))
rs("chuliquer")=trim(request.form("chuliquer"))
rs("chulibc")=trim(request.form("chulibc"))
rs("select5")=trim(request.form("select5"))
rs("beijihao")=trim(request.form("beijihao"))
rs("fujianbuc")=trim(request.form("fujianbuc"))
rs("guzhangquren")=trim(request.form("guzhangquren"))
rs("time")=trim(request.form("time"))
rs("chuanhao1")=trim(request.form("chuanhao1"))
rs("chulinr")=trim(request.form("chulinr"))
rs("select")=trim(request.form("select"))
rs("bujianm")=trim(request.form("bujianm"))
rs("weixiou")=trim(request.form("weixiou"))
rs("jiedai")=trim(request.form("jiedai"))
rs("luru")=trim(request.form("luru"))
rs("beizhu")=trim(request.form("beizhu"))
rs("quji")=trim(request.form("quji"))
rs.update
rs.close
set rs=nothing
response.write("<script language='javascript'>alert('修改成功!');window.location.href='article_list.asp'</script>")
%>
chgart.asp:
<!--#include file="conn.asp"-->
<!--#include file="../riqi.htm"-->
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
color: #000000;
}
.STYLE1 {
font-size: 12px;
font-weight: bold;
}
.STYLE2 {color: #FF0000}
-->
</style>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
body,td,th {
font-size: 12px;
color: #000000;
}
a:link {
color: #000000;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #000000;
}
a:hover {
text-decoration: none;
color: #000000;
}
a:active {
text-decoration: none;
color: #000000;
}
.STYLE2 {
font-size: 36px;
font-weight: bold;
}
-->
</style>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from article where art_id=" & request("id")
rs.open sql,conn,1,3
%>
<title>工单填写</title>
<form name="form" method="post" action="saveaddnews1.asp">
<input type="hidden" name="id" value="<%=request("id")%>">
<table width="100%" height="59" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><span class="STYLE2">移动电话维修工单</span></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td height="12" colspan="3">维修单位:武汉鑫霞光通讯器材有限公司</td>
</tr>
<tr>
<td width="68%" height="12" rowspan="2">服务电话:027-87814810 027-82805672 传真:027-82805672</td>
<td width="9%" align="center">台帐单号: </td>
<td width="23%" align="center"><%=rs("shoug")%></td>
</tr>
<tr>
<td align="center">系统单号:</td>
<td align="center"><%=rs("danhao")%></td>
</tr>
<tr>
<td height="16"><span class="STYLE1">以下内容请务必填写真实内容,并确定准确性!*号的内容请勿修改</span></td>
<td align="center">送修日期:</td>
<td align="center"><input name="time1" type="text" id="time1" style="width:120px;" onclick="setday(this)" value="<%=rs("time1")%>" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">经销商: </td>
<td width="23%" height="18" align="center"><input name="jinxiaos" type="text" id="jinxiaos" value="<%=rs("jinxiaos")%>" size="25"></td>
<td width="11%" height="18" align="center">经销商电话: </td>
<td width="25%" align="center"><input name="jinxiaosdh" type="text" id="jinxiaosdh" value="<%=rs("jinxiaosdh")%>" size="25"></td>
<td align="center">索爱出厂号:</td>
<td align="center"><input name="chuchao" type="text" id="chuchao" value="<%=rs("chuchao")%>" size="25" /></td>
</tr>
<tr>
<td height="18" align="center">机主姓名:</td>
<td height="18" align="center"><input name="typename" type="text" id="typename" value="<%=rs("typename")%>" size="25"></td>
<td height="18" align="center">手机号码:</td>
<td height="18" align="center"><input name="dianhua" type="text" id="dianhua" value="<%=rs("dianhua")%>" size="25"></td>
<td width="9%" height="18" align="center">手机编码:</td>
<td width="23%" align="center"><%=rs("textfield")%></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">联系电话:</td>
<td width="23%" align="center"><input name="dianhua1" type="text" id="dianhua1" value="<%=rs("dianhua1")%>" size="25"></td>
<td width="11%" align="center">购机地点:</td>
<td width="25%" align="center" valign="middle"><input name="didian" type="text" id="didian" value="湖北省武汉市" size="25"></td>
<td width="9%" align="center">购买日期:</td>
<td width="23%" align="center"><input name="riqi" type="text" id="riqi" style="width:120px;" onclick="setday(this)" value="<%=rs("riqi")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">通讯地址:</td>
<td width="23%" align="center"><input name="dizhi" type="text" id="dizhi" value="<%=rs("dizhi")%>" size="25"></td>
<td width="11%" align="center">发票号码:</td>
<td width="25%" align="center"><input name="fapiaohao" type="text" id="fapiaohao" value="<%=rs("fapiaohao")%>" size="25" /></td>
<td width="9%" align="center">进站外观:</td>
<td width="23%" align="center"><input name="youz" type="text" id="youz" value="<%=rs("youz")%>" size="25"></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">故障描述:</td>
<td width="23%" align="center">
<select name="select2">
<option value="" <%if rs("select2")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="不能开机" <%if rs("select2")="不能开机" then%>selected<%end if%>>不能开机</option>
<option value="没有信号" <%if rs("select2")="没有信号" then%>selected<%end if%>>没有信号</option>
<option value="耗电" <%if rs("select2")="耗电" then%>selected<%end if%>>耗电</option>
<option value="不充电" <%if rs("select2")="不充电" then%>selected<%end if%>>不充电</option>
<option value="死机" <%if rs("select2")="死机" then%>selected<%end if%>>死机</option>
<option value="屏幕不显示" <%if rs("select2")="屏幕不显示" then%>selected<%end if%>>屏幕不显示</option>
<option value="不读卡" <%if rs("select2")="不读卡" then%>selected<%end if%>>不读卡</option>
<option value="按键失灵" <%if rs("select2")="按键失灵" then%>selected<%end if%>>按键失灵</option>
<option value="不送话" <%if rs("select2")="不送话" then%>selected<%end if%>>不送话</option>
<option value="不受话" <%if rs("select2")="不受话" then%>selected<%end if%>>不受话</option>
<option value="自动关机" <%if rs("select2")="自动关机" then%>selected<%end if%>>自动关机</option>
</select>
</td>
<td width="11%" align="center">品牌:</td>
<td width="25%" align="center"><script language="VBScript" type="text/vbscript">
sub aa()
if form.sel.value="索爱" then
form.textfield.value="1"
elseif form.sel.value="NEC" then
form.textfield.value="2"
elseif form.sel.value="酷派" then
form.textfield.value="3"
elseif form.sel.value="其乐" then
form.textfield.value="4"
elseif form.sel.value="振华" then
form.textfield.value="5"
elseif form.sel.value="厦新" then
form.textfield.value="6"
elseif form.sel.value="其它" then
form.textfield.value="7"
end if
end sub
</script>
<select name="sel" id="sel"onchange="aa()">
<option value="" <%if rs("sel")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="索爱" <%if rs("sel")="索爱" then%>selected<%end if%>>索爱</option>
<option value="NEC" <%if rs("sel")="NEC" then%>selected<%end if%>>NEC</option>
<option value="酷派" <%if rs("sel")="酷派" then%>selected<%end if%>>酷派</option>
<option value="其乐" <%if rs("sel")="其乐" then%>selected<%end if%>>其乐</option>
<option value="振华" <%if rs("sel")="振华" then%>selected<%end if%>>振华</option>
<option value="厦新">厦新</option>
<option value="其它" <%if rs("sel")="其它" then%>selected<%end if%>>其它</option>
</select>
</td>
<td width="9%" align="center">机型:</td>
<td width="23%" align="center"><input name="guzhang" type="text" id="guzhang" value="<%=rs("guzhang")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">颜色:</td>
<td width="23%" align="center"><select name="yanse" id="yanse">
<option value="" <%if rs("yanse")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="黑色" <%if rs("yanse")="黑色" then%>selected<%end if%>>黑色</option>
<option value="白色" <%if rs("yanse")="白色" then%>selected<%end if%>>白色</option>
<option value="红色" <%if rs("yanse")="红色" then%>selected<%end if%>>红色</option>
<option value="银色" <%if rs("yanse")="银色" then%>selected<%end if%>>银色</option>
<option value="紫色" <%if rs("yanse")="紫色" then%>selected<%end if%>>紫色</option>
<option value="蓝色" <%if rs("yanse")="蓝色" then%>selected<%end if%>>蓝色</option>
<option value="黑白色" <%if rs("yanse")="黑白色" then%>selected<%end if%>>黑白色</option>
<option value="银黑色" <%if rs("yanse")="银黑色" then%>selected<%end if%>>银黑色</option>
<option value="其它" <%if rs("yanse")="其它" then%>selected<%end if%>>其它</option>
</select>
</td>
<td width="11%" align="center">索爱DPY:</td>
<td width="25%" align="center"><input name="DPY" type="text" id="DPY" value="<%=rs("DPY")%>" size="25" /></td>
<td width="9%" align="center">酷派ESN:</td>
<td width="23%" align="center"><input name="ESM" type="text" id="ESM" value="<%=rs("ESM")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">IMEI:</td>
<td width="23%" align="center"><input name="chuanhao" type="text" id="chuanhao" value="<%=rs("chuanhao")%>" size="25" /></td>
<td width="11%" align="center">随机配件:</td>
<td width="25%" align="center"><select name="fujian" id="fujian">
<option value="" <%if rs("fujian")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="单机头" <%if rs("fujian")="单机头" then%>selected<%end if%>>单机头</option>
<option value="耳机" <%if rs("fujian")="耳机" then%>selected<%end if%>>耳机</option>
<option value="电池" <%if rs("fujian")="电池" then%>selected<%end if%>>电池</option>
<option value="座充" <%if rs("fujian")="座充" then%>selected<%end if%>>座充</option>
<option value="线充" <%if rs("fujian")="线充" then%>selected<%end if%>>线充</option>
<option value="电池盖" <%if rs("fujian")="电池盖" then%>selected<%end if%>>电池盖</option>
<option value="包装盒" <%if rs("fujian")="包装盒" then%>selected<%end if%>>包装盒</option>
<option value="数据线" <%if rs("fujian")="数据线" then%>selected<%end if%>>数据线</option>
<option value="手写笔" <%if rs("fujian")="手写笔" then%>selected<%end if%>>手写笔</option>
<option value="机头/电池" <%if rs("fujian")="机头/电池" then%>selected<%end if%>>机头/电池</option>
<option value="机头/电池/充电器" <%if rs("fujian")="机头/电池/充电器" then%>selected<%end if%>>机头/电池/充电器</option>
<option value="机头/电池盖/电池" <%if rs("fujian")="机头/电池盖/电池" then%>selected<%end if%>>机头/电池盖/电池</option>
</select>
</td>
<td width="9%" align="center">附件补充/序号:</td>
<td width="23%" align="center"><input name="xuhao" type="text" id="xuhao" value="<%=rs("xuhao")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">维修次数:</td>
<td width="23%" align="center"><input name="cishu" type="text" id="cishu" value="<%=rs("cishu")%>" size="25" /></td>
<td width="11%" align="center">维修性质:</td>
<td width="25%" align="center"><select name="xinzi" id="xinzi">
<option value="" <%if rs("xinzi")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="保修" <%if rs("xinzi")="保修" then%>selected<%end if%>>保修</option>
<option value="非保" <%if rs("xinzi")="非保" then%>selected<%end if%>>非保</option>
<option value="其它" <%if rs("xinzi")="其它" then%>selected<%end if%>>其它</option>
</select></td>
<td width="9%" align="center">维修报价:</td>
<td width="23%" align="center"><input name="baojia" type="text" id="baojia" value="<%=rs("baojia")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">是否维修:</td>
<td width="23%" align="center"><select name="select3">
<option value="" <%if rs("select3")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="同意维修" <%if rs("select3")="同意维修" then%>selected<%end if%>>同意维修</option>
<option value="不同意维修" <%if rs("select3")="不同意维修" then%>selected<%end if%>>不同意维修</option>
<option value="其它" <%if rs("select3")="其它" then%>selected<%end if%>>其它</option>
</select> </td>
<td width="11%" align="center">处理确认:</td>
<td width="25%" align="center"><select name="chuliquer" id="chuliquer">
<option value="" <%if rs("chuliquer")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="维修" <%if rs("chuliquer")="维修" then%>selected<%end if%>>维修</option>
<option value="换板" <%if rs("chuliquer")="换板" then%>selected<%end if%>>换板</option>
<option value="返厂维修" <%if rs("chuliquer")="返厂维修" then%>selected<%end if%>>返厂维修</option>
<option value="DOA/DAP" <%if rs("chuliquer")="DOA/DAP" then%>selected<%end if%>>DOA/DAP</option>
<option value="多维换机" <%if rs("chuliquer")="多维换机" then%>selected<%end if%>>多维换机</option>
<option value="换排线" <%if rs("chuliquer")="换排线" then%>selected<%end if%>>换排线</option>
<option value="换屏" <%if rs("chuliquer")="换屏" then%>selected<%end if%>>换屏</option>
<option value="换听筒" <%if rs("chuliquer")="换听筒" then%>selected<%end if%>>换听筒</option>
<option value="换外壳" <%if rs("chuliquer")="换外壳" then%>selected<%end if%>>换外壳</option>
<option value="重装" <%if rs("chuliquer")="重装" then%>selected<%end if%>>重装</option>
<option value="软件升级" <%if rs("chuliquer")="软件升级" then%>selected<%end if%>>软件升级</option>
<option value="换送话器" <%if rs("chuliquer")="换送话器" then%>selected<%end if%>>换送话器</option>
<option value="换按键" <%if rs("chuliquer")="换按键" then%>selected<%end if%>>换按键</option>
<option value="清洗" <%if rs("chuliquer")="清洗" then%>selected<%end if%>>清洗</option>
</select></td>
<td width="9%" align="center">处理补充:</td>
<td width="23%" align="center"><input name="chulibc" type="text" id="chulibc" value="<%=rs("chulibc")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">提供备机:</td>
<td width="23%" align="center"><select name="select5">
<option value="" <%if rs("select5")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="提供" <%if rs("select5")="提供" then%>selected<%end if%>>提供</option>
<option value="不提供" <%if rs("select5")="不提供" then%>selected<%end if%>>不提供</option>
</select></td>
<td width="11%" align="center">机型/序号:</td>
<td width="25%" align="center"><input name="beijihao" type="text" id="beijihao" value="<%=rs("beijihao")%>" size="25" /></td>
<td width="9%" align="center">附件补充:</td>
<td width="23%" align="center"><input name="fujianbuc" type="text" id="fujianbuc" value="<%=rs("fujianbuc")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">故障确认:</td>
<td width="23%" align="center"><input name="guzhangquren" type="text" id="guzhangquren" value="<%=rs("guzhangquren")%>" size="25" /></td>
<td width="11%" align="center">取机时间:</td>
<td width="25%" align="center"><input name="time" type="text" id="time" style="width:120px;" onclick="setday(this)" value="<%=rs("time")%>" size="25" /></td>
<td width="9%" align="center">故障判断:</td>
<td width="23%" align="center"><select name="select">
<option value="" <%if rs("select")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="可在现" <%if rs("select")="可在现" then%>selected<%end if%>>可在现</option>
<option value="未在现" <%if rs("select")="未在现" then%>selected<%end if%>>未在现</option>
</select> </td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="18" align="center">处理内容:</td>
<td width="23%" align="center"><select name="chulinr">
<option value="" <%if rs("chulinr")="" then%>selected<%end if%>>---请选择故障---</option>
<option value="维修" <%if rs("chulinr")="维修" then%>selected<%end if%>>维修</option>
<option value="换板" <%if rs("chulinr")="换板" then%>selected<%end if%>>换板</option>
<option value="返厂维修" <%if rs("chulinr")="返厂维修" then%>selected<%end if%>>返厂维修</option>
<option value="DOA/DAP" <%if rs("chulinr")="DOA/DAP" then%>selected<%end if%>>DOA/DAP</option>
<option value="多维换机" <%if rs("chulinr")="多维换机" then%>selected<%end if%>>多维换机</option>
<option value="换排线" <%if rs("chulinr")="换排线" then%>selected<%end if%>>换排线</option>
<option value="换屏" <%if rs("chulinr")="换屏" then%>selected<%end if%>>换屏</option>
<option value="换听筒" <%if rs("chulinr")="换听筒" then%>selected<%end if%>>换听筒</option>
<option value="换外壳" <%if rs("chulinr")="换外壳" then%>selected<%end if%>>换外壳</option>
<option value="重装" <%if rs("chulinr")="重装" then%>selected<%end if%>>重装</option>
<option value="软件升级" <%if rs("chulinr")="软件升级" then%>selected<%end if%>>软件升级</option>
<option value="换送话器" <%if rs("chulinr")="换送话器" then%>selected<%end if%>>换送话器</option>
<option value="换按键" <%if rs("chulinr")="换按键" then%>selected<%end if%>>换按键</option>
<option value="清洗" <%if rs("chulinr")="清洗" then%>selected<%end if%>>清洗</option>
</select></td>
<td width="11%" align="center">换机/板后IMEI:</td>
<td width="25%" align="center"><input name="chuanhao1" type="text" id="chuanhao1" value="<%=rs("chuanhao1")%>" size="25" /></td>
<td width="9%" align="center">更换零件名:</td>
<td width="23%" align="center"><input name="bujianm" type="text" id="bujianm" value="<%=rs("bujianm")%>" size="25" /></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="9%" height="29" align="center" valign="middle">维修工程师:</td>
<td width="23%" align="center" valign="middle"><%=rs("weixiou")%>
</td>
<td width="11%" align="center">接待员:</td>
<td width="25%" align="center"><%=rs("jiedai")%></td>
<td width="9%" align="center">系统录入员:</td>
<td width="23%" align="center"><%=rs("luru")%></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D6DFF7" style="border-collapse:collapse">
<tr>
<td width="8%" height="29" align="center" valign="middle">备注:</td>
<td width="60%" align="center" valign="middle"><input name="beizhu" type="text" id="beizhu" value="<%=rs("beizhu")%>" size="70" /></td>
<td width="9%" align="center" valign="middle">是否取机:</td>
<td width="23%" align="center" valign="middle"><select name="quji" id="quji">
<option value="" <%if rs("quji")="" then%>selected<%end if%>>---请选择---</option>
<option value="已取" <%if rs("quji")="已取" then%>selected<%end if%>>已取</option>
<option value="未取" <%if rs("quji")="未取" then%>selected<%end if%>>未取</option>
</select></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="37"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="41" align="center" valign="middle"><div align="center">
<input type="submit" name="Submit" value="确认提交" />
<input type="reset" name="Submit2" value="重置表单" />
</div></td>
</tr>
</table>
有问题再说吧