ASP数据库批量修改的问题.求助!
本人不才.初学ASP.现在有个问题.这个批量修改的代码哪里有错误啊. 本人不胜感激!QQ:253982
<!--#include file="conn.asp"-->
<title>管理商品</title>
<link href="../images/css.css" rel="stylesheet" type="text/css">
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆!');window.location.href='login.asp';</script>"
response.End
else
if session("flag")>1 then
response.Write "<p align=center><font color=red>您没有此项目管理权限!</font></p>"
response.End
end if
end if
%>
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<%
dim action
action=request.QueryString("action")
select case action
case "prolist"
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from products",conn,1,3
rs("huiyuanjia")=trim(request("huiyuanjia"))
rs.update
set rs=nothing
response.Write "<script language=javascript>alert('修改成功!');history.go(-1);</script>"
response.End
end select
%>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6699cc">
<tr>
<td align="center" background="../images/admin_bg_1.gif" height="25"><b><font color="#ffffff">品批量修改功能</font></b>