asp怎么实现修改一个表，又更新一条数据
答案:2 悬赏:40 手机版
解决时间 2021-03-29 23:16
- 提问者网友：人生佛魔见
- 2021-03-29 12:09
asp怎么实现修改一个表，又更新一条数据
最佳答案
- 五星知识达人网友：酒者煙囻
- 2021-03-29 12:26
<% if request.querystring("action")="dh" then
conn.execute("Insert Into mc_paidui (cart,uid,uniacid,sh,datetime) values ('"&trim(request.form("cart"))&"',"&server.HTMLEncode(trim(request.form("uid")))&","&server.HTMLEncode(trim(request.form("uniacid")))&","&server.HTMLEncode(trim(request.form("sh")))&",'"&trim(request.form("datetime"))&"')") '注数字型用"&&",文本型用'"&&"',自己核实一下
set rs=server.createobject("adodb.recordset")
sql="select * from ims_mc_members where uid="&request.form("uid")&" "
rs.open sql,conn,1,3
rs("credit1")=trim(request.form("credit1"))
rs.update
response.Write ""
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
conn.execute("Insert Into mc_paidui (cart,uid,uniacid,sh,datetime) values ('"&trim(request.form("cart"))&"',"&server.HTMLEncode(trim(request.form("uid")))&","&server.HTMLEncode(trim(request.form("uniacid")))&","&server.HTMLEncode(trim(request.form("sh")))&",'"&trim(request.form("datetime"))&"')") '注数字型用"&&",文本型用'"&&"',自己核实一下
set rs=server.createobject("adodb.recordset")
sql="select * from ims_mc_members where uid="&request.form("uid")&" "
rs.open sql,conn,1,3
rs("credit1")=trim(request.form("credit1"))
rs.update
response.Write ""
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
全部回答
- 1楼网友：一把行者刀
- 2021-03-29 13:26
把两段代码写到asp文件里面应该就可以了吧。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯