请教这段ASP代码怎么修改

来源:百度知道 编辑:UC知道 时间:2024/05/12 12:24:40
<!-- #include file="conn.asp" -->
<%
type_id=Request.Form("new_type_id")
type_son_id=Request.Form("new_type_son_id")
brand_id=Request.Form("new_brand_id")
new_pro_id_1=Request.Form("new_pro_id_1")
new_pro_id_2=Trim(Request.Form("new_pro_id_2"))
new_pro_radio=Request.Form("new_pro_radio")
price=Trim(request.form("price"))
price_in=Trim(request.form("price_in"))
com_id=session("com_id")
if new_pro_radio=1 then
pro_id=new_pro_id_1
else
set rs=server.createobject("adodb.recordset")
sql="select * from products"
rs.open sql,conn,1,3
rs.addnew
rs("type_id")=type_id
rs("type_son_id")=type_son_id
rs("brand_id")=brand_id
rs("pro_name")=new_pro_id_2
rs("pas")=0
rs("hit")=0

把换成你想修改的语句就可以了
sql2="update user set name='"&name1&"',email='"&email&"',add='"&add&"',tel='"&tel&"' where id="&id
conn.execute sql2
具体的什么自己弄