Question

ASP修改数据库记录问题

前台
<label>
<input name="radiobutton2" type="radio" value="2" />
</label></td>
<td align="center"><label>
<input type="radio" name="radiobutton1" value="1" />
</label>

后台
<!--#include file="conn1.asp"-->
<%
dim rs
set rs=Server.CreateObject("Adodb.Recordset")
rs.open "Select * from lx where id="&request("id")&" ",conn,1,3
xs=request.Form("radiobutton1")
wz=request.Form("radiobutton2")
rs("xs")=xs
rs("wz")=wz

rs.update

%>
为什么 xs wz 的 值都是空的 。怎么改过来呢 ？

Answer 1

首先要确定你的
request("id")
request.Form("radiobutton1")
request.Form("radiobutton2")
都有值
确定的方法是在dim rs前面加上
response.write request("id")
response.write request.Form("radiobutton1")
response.write request.Form("radiobutton2")
response.end

Answer 2

不是request("id")而是request.Form("id")
你也可以这么些。

set rs=Server.CreateObject("Adodb.Recordset")
xs=request.Form("radiobutton1")
wz=request.Form("radiobutton2")
ID=request.Form("id")
rs.open "Select * from lx where id="&ID,conn,1,3
rs("xs")=xs
rs("wz")=wz

rs.update