asp数据库无法更新更新;数据库update无法更新
显示更新成功,可是数据库密码还是原来的!请哪位上仙帮忙给看看!小弟我这先谢过了!其中该表中有个gonggao字段,通过别的页面的相关代码可以更新gonggao字段的值,但...
显示更新成功,可是数据库密码还是原来的!请哪位上仙帮忙给看看!小弟我这先谢过了!
其中该表中有个gonggao字段,通过别的页面的相关代码可以更新gonggao字段的值,但是通过下面的代码更新代码中的字段,却无法更新,显示更新成功,数据库数据还是原来的。
<%dim action
action=request.QueryString("action")
'//保存信息
if action="save" then
ly=trim(request.form("ly"))
login=trim(request.form("login"))
vote=trim(request.form("vote"))
links=trim(request.form("links"))
fl=trim(request.form("fl"))
flsl=trim(request.form("flsl"))
fll=trim(request.form("fll"))
shop_setup=ly&","&login&","&vote&","&links&","&fl&","&flsl&","&fll
StrSql = "select * from shopxp_setup"
set rs=server.CreateObject("adodb.recordset")
rs.Open StrSql,conn,1,3
rs("webname")=trim(request.form("webname"))
rs("webemail")=trim(request.form("webemail"))
rs("dizhi")=trim(request.form("dizhi"))
rs("youbian")=trim(request.form("youbian"))
rs("dianhua")=trim(request.form("dianhua"))
rs("copyright")=trim(request.form("copyright"))
rs("weblogo")=trim(request.form("weblogo"))
rs("webbanner")=trim(request.form("webbanner"))
rs("weburl")=trim(request.form("weburl"))
rs("qqzt")=request.form("qqzt")
rs("paypin")=trim(request.form("paypin"))
rs("payid")=request.form("payid")
rs("payurl")=request.form("payurl")
rs("alipayid")=request.form("alipayid")
rs("alipaymd5")=request.form("alipaymd5")
rs("zuixin")=request.form("zuixin")
rs("tuijian")=request.form("tuijian")
rs("tejia")=request.form("tejia")
rs("xtk")=request.form("xtk")
rs("xtg")=request.form("xtg")
rs("dtk")=request.form("dtk")
rs("dtg")=request.form("dtg")
rs("shop_setup")=shop_setup
rs.update
rs.close
Set rs=Nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('资料修改成功!');" & Chr(13)
response.write "window.document.location.href='shopxp.asp';"&Chr(13)
response.write "</script>" & Chr(13)
end if
%>
gonggao字段在别的页面用相关的更新代码可以更新。我说的现在该问题中,代码里所包含的字段无法更新,如webname字段。无法更新。 展开
其中该表中有个gonggao字段,通过别的页面的相关代码可以更新gonggao字段的值,但是通过下面的代码更新代码中的字段,却无法更新,显示更新成功,数据库数据还是原来的。
<%dim action
action=request.QueryString("action")
'//保存信息
if action="save" then
ly=trim(request.form("ly"))
login=trim(request.form("login"))
vote=trim(request.form("vote"))
links=trim(request.form("links"))
fl=trim(request.form("fl"))
flsl=trim(request.form("flsl"))
fll=trim(request.form("fll"))
shop_setup=ly&","&login&","&vote&","&links&","&fl&","&flsl&","&fll
StrSql = "select * from shopxp_setup"
set rs=server.CreateObject("adodb.recordset")
rs.Open StrSql,conn,1,3
rs("webname")=trim(request.form("webname"))
rs("webemail")=trim(request.form("webemail"))
rs("dizhi")=trim(request.form("dizhi"))
rs("youbian")=trim(request.form("youbian"))
rs("dianhua")=trim(request.form("dianhua"))
rs("copyright")=trim(request.form("copyright"))
rs("weblogo")=trim(request.form("weblogo"))
rs("webbanner")=trim(request.form("webbanner"))
rs("weburl")=trim(request.form("weburl"))
rs("qqzt")=request.form("qqzt")
rs("paypin")=trim(request.form("paypin"))
rs("payid")=request.form("payid")
rs("payurl")=request.form("payurl")
rs("alipayid")=request.form("alipayid")
rs("alipaymd5")=request.form("alipaymd5")
rs("zuixin")=request.form("zuixin")
rs("tuijian")=request.form("tuijian")
rs("tejia")=request.form("tejia")
rs("xtk")=request.form("xtk")
rs("xtg")=request.form("xtg")
rs("dtk")=request.form("dtk")
rs("dtg")=request.form("dtg")
rs("shop_setup")=shop_setup
rs.update
rs.close
Set rs=Nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('资料修改成功!');" & Chr(13)
response.write "window.document.location.href='shopxp.asp';"&Chr(13)
response.write "</script>" & Chr(13)
end if
%>
gonggao字段在别的页面用相关的更新代码可以更新。我说的现在该问题中,代码里所包含的字段无法更新,如webname字段。无法更新。 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询