<% strID=replace(request.form("chkbox"),", ","")'去掉空格 sql="UPDATE 表 SET 字段=AAA WHERE ID IN ("&strID&")"%> ..... ..... <% FOR I=0 TO RS.RECORDCOUNT-1 <INPUT TYPE=CHECKBOX NAME=chkbox VALUE='<%=rs("ID")%>'> RS.MOVENEXT NEXT RS.CLOSE %> .........
在数据库中是否还要建立一个id 对应保存checkbox
toury 的 上面id为你库中主键
你数据库中没有索引字段吗?通常都有一个主键字段嘛; 如果数据库中没有,最好建一个;实在不想建,那就: <% strID=replace(request.form("chkbox"),", ","")'去掉空格 '索引字段为数字 sql="UPDATE 表 SET 字段=AAA WHERE 索引字段 IN ("&strID&")" '索引字段为文本,用下面的: 'sql="UPDATE 表 SET 字段=AAA WHERE 索引字段 IN ('"&strID&"')"%> ..... ..... <% FOR I=0 TO RS.RECORDCOUNT-1 <INPUT TYPE=CHECKBOX NAME=chkbox VALUE='"&rs("索引字段")&"'>'5楼这里写错,不能<%=rs("ID")%>,用&& RS.MOVENEXT NEXT RS.CLOSE %> .........
不行啊 这是我的1.asp <form name="form1" action="update.asp" method="post"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <% do while not rs.eof %><tr> <td><%=rs("name")%></td> <td><%=rs("tel")%></td> <td><%=rs("message")%></td> <td><%=rs("time")%></td> <td><input type="checkbox" name="update" value="<%=rs("id")%>"></td> </tr> <% rs.movenext loop %> </table><input type="submit" name="updatebn" value="更新"> </form> 2、这是update.asp <% strID=replace(request.form("chk_id"),", ","")'去掉空格 sql="UPDATE guestbook SET name='cc' WHERE id IN ("&strID&")" response.Write "记录已成功更新"%> 怎么还是不行啊
UPDATE.ASP ----------------------------<% strID=replace(request.form("update"),",","")'去掉空格 if strID=empty then response.write "什么都没传过来嘛!" response.end end if sql="UPDATE [guestbook] SET name='cc' WHERE id IN ("&strID&")" response.write sql'输出语句,拷贝粘贴到数据库查询里运行一下看什么错误 conn.execute sql '才发现你怎么连这句都省略了~~我5楼代码是个示范,没写全的:( if err=0 then response.Write "记录已成功更新" else response.Write "更新失败!原因:" &err.description end if%>
<%
strID=replace(request.form("chkbox"),", ","")'去掉空格
sql="UPDATE 表 SET 字段=AAA WHERE ID IN ("&strID&")"%>
.....
.....
<%
FOR I=0 TO RS.RECORDCOUNT-1
<INPUT TYPE=CHECKBOX NAME=chkbox VALUE='<%=rs("ID")%>'>
RS.MOVENEXT
NEXT
RS.CLOSE
%>
.........
上面id为你库中主键
如果数据库中没有,最好建一个;实在不想建,那就:
<%
strID=replace(request.form("chkbox"),", ","")'去掉空格
'索引字段为数字
sql="UPDATE 表 SET 字段=AAA WHERE 索引字段 IN ("&strID&")"
'索引字段为文本,用下面的:
'sql="UPDATE 表 SET 字段=AAA WHERE 索引字段 IN ('"&strID&"')"%>
.....
.....
<%
FOR I=0 TO RS.RECORDCOUNT-1
<INPUT TYPE=CHECKBOX NAME=chkbox VALUE='"&rs("索引字段")&"'>'5楼这里写错,不能<%=rs("ID")%>,用&&
RS.MOVENEXT
NEXT
RS.CLOSE
%>
.........
<form name="form1" action="update.asp" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
do while not rs.eof
%><tr>
<td><%=rs("name")%></td>
<td><%=rs("tel")%></td>
<td><%=rs("message")%></td>
<td><%=rs("time")%></td>
<td><input type="checkbox" name="update" value="<%=rs("id")%>"></td>
</tr>
<%
rs.movenext
loop
%>
</table><input type="submit" name="updatebn" value="更新">
</form>
2、这是update.asp
<%
strID=replace(request.form("chk_id"),", ","")'去掉空格 sql="UPDATE guestbook SET name='cc' WHERE id IN ("&strID&")" response.Write "记录已成功更新"%>
怎么还是不行啊
chk_id"),",","")strID=replace(request.form("update"),",","")'==============
怀疑你没看过教程就来写程序了哦,呵呵
chk_id"),",","")用这个:
strID=replace(request.form("update"),",","")'
==============
怀疑你没看过教程就来写程序了哦,呵呵
----------------------------<%
strID=replace(request.form("update"),",","")'去掉空格
if strID=empty then
response.write "什么都没传过来嘛!"
response.end
end if sql="UPDATE [guestbook] SET name='cc' WHERE id IN ("&strID&")"
response.write sql'输出语句,拷贝粘贴到数据库查询里运行一下看什么错误
conn.execute sql '才发现你怎么连这句都省略了~~我5楼代码是个示范,没写全的:(
if err=0 then
response.Write "记录已成功更新"
else
response.Write "更新失败!原因:" &err.description
end if%>
感谢toury 的帮助!!!让我学的快又有印象