ASP中,提交数据后,存不进数据库中呀!急救!!!!!!!!!大哥大姐们
代码如下:
<%dim action
action=request.QueryString( "action ")
if action= "save " then
set rs=server.CreateObject( "adodb.recordset ")
rs.Open "select payid,paypin,payurl,npayid,npaypin,npayurl,westid,westurl,ipayid,ipaypin,ipayurl,ypayid,ypaypin,ypayurl from webinfo ",conn,1,3
rs( "paypin ")=trim(request( "paypin "))
rs( "payid ")=request( "payid ")
rs( "payurl ")=request( "payurl ")
rs( "npaypin ")=trim(request( "npaypin "))
rs( "npayid ")=request( "npayid ")
rs( "npayurl ")=request( "npayurl ")
rs( "ipaypin ")=trim(request( "ipaypin "))
rs( "ipayid ")=trim(request( "ipayid "))
rs( "ipayurl ")=trim(request( "ipayurl "))
rs( "ypayid ")=trim(request( "ypayid "))
rs( "ypaypin ")=trim(request( "ypaypin "))
rs( "ypayurl ")=trim(request( "ypayurl "))
rs( "westid ")=request( "westid ")
rs( "westurl ")=request( "westurl ")
rs.update
rs.close
set rs=nothing
response.Write " <script language=javascript> alert( '网站资料修改成功！ ');history.go(-1); </script> "
end if%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
</head>
<body>
<table class= "tableBorder " width= "100% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "1 " >
<tr>
<td height= "25 " align= "center " background= "../images/admin_bg_1.gif "> <b> <font color= "#ffffff "> 在线支付设置 </font> </b> </td>
</tr>
<tr>
<td height= "107 " valign= "top " >
<table border= "0 " cellpadding= "0 " cellspacing= "1 " width= "100% ">
<tr>
<td width= "100% "> </td>
</tr>
<tr>
<td width= "100% "> <table width= "500 " border= "0 " align= "center " cellpadding= "3 " cellspacing= "0 ">
<form name= "form1 " method= "post " action= "onlinepay.asp?action=save ">
<%set rs=server.CreateObject( "adodb.recordset ")
rs.Open "select * from webinfo ",conn,1,1%>
<tr align= "center " >
<td height= "22 " colspan= "2 "> 网银在线支付配置 </td>
</tr>
<tr >
<td width= "73 " height= "22 "> <div align= "left "> 商户ID： </div> </td>
<td width= "462 " height= "22 "> <input name= "payid " type= "text " id= "payid " size= "36 " value= " <%=trim(rs( "payid "))%> ">
</td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> MD5密钥： </div> </td>
<td height= "22 "> <input name= "paypin " type= "text " id= "paypin " size= "36 " value= " <%=trim(rs( "paypin "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> <div align= "left "> 返回地址： </div> </td>
<td height= "2 "> <input name= "payurl " type= "text " id= "payurl " size= "36 " value= " <%=trim(rs( "payurl "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> </td>
<td height= "3 "> </td>
</tr>
<tr align= "center " >
<td height= "22 " colspan= "2 "> NPS在线支付配置 </td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> 商户号码： </div> </td>
<td height= "22 "> <input name= "npayid " type= "text " id= "npayid " size= "36 " value= " <%=trim(rs( "npayid "))%> ">
</td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> MD5密钥： </div> </td>
<td height= "22 "> <input name= "npaypin " type= "text " id= "npaypin " size= "36 " value= " <%=trim(rs( "npaypin "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> <div align= "left "> 返回地址： </div> </td>
<td height= "2 "> <input name= "npayurl " type= "text " id= "npayurl " size= "36 " value= " <%=trim(rs( "npayurl "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> </td>
<td height= "0 "> </td>
</tr>
<tr align= "center " >
<td height= "22 " colspan= "2 "> 快钱支付接口配置 </td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> 支付ID： </div> </td>
<td height= "22 "> <input name= "ipayid " type= "text " id= "ipayid " size= "36 " value= " <%=trim(rs( "ipayid "))%> ">
</td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> MD5密钥： </div> </td>
<td height= "22 "> <input name= "ipaypin " type= "text " id= "ipaypin " size= "36 " value= " <%=trim(rs( "ipaypin "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> <div align= "left "> 返回地址： </div> </td>
<td height= "5 "> <input name= "ipayurl " type= "text " id= "ipayurl " size= "36 " value= " <%=trim(rs( "ipayurl "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> </td>
<td height= "5 "> </td>
</tr>
<tr align= "center " >
<td height= "22 " colspan= "2 "> 云网在线支付接口 </td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> 支付ID： </div> </td>
<td height= "22 "> <input name= "ypayid " type= "text " id= "ypayid " size= "36 " value= " <%=trim(rs( "ypayid "))%> ">
</td>
</tr>
<tr >
<td height= "22 "> <div align= "left "> MD5密钥： </div> </td>
<td height= "22 "> <input name= "ypaypin " type= "text " id= "ypaypin " size= "36 " value= " <%=trim(rs( "ypaypin "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> <div align= "left "> 返回地址： </div> </td>
<td height= "2 "> <input name= "ypayurl " type= "text " id= "ypayurl " size= "36 " value= " <%=trim(rs( "ypayurl "))%> ">
</td>
</tr>
<tr >
<td height= "0 "> </td>
<td height= "3 "> </td>
</tr>
<tr >
<td height= "11 " colspan= "2 "> <div align= "center "> 西部支付接口配置 </div> </td>
</tr>
<tr >
<td height= "0 "> 支付ID： </td>
<td height= "22 "> <input name= "westid " type= "text " size= "36 " value= " <%=trim(rs( "westid "))%> "> </td>
</tr>
<tr >
<td height= "11 "> 返回地址： </td>
<td height= "11 "> <input name= "westurl " type= "text " size= "36 " value= " <%=trim(rs( "westurl "))%> "> </td>
</tr>
<tr>
<td height= "22 " colspan= "2 "> <div align= "center ">
<input class= "button " type= "submit " name= "Submit " value= "提 交 ">
<input class= "button " type= "reset " name= "Submit2 " value= "恢 复 ">
</div> </td>
</tr>
</form>
</table>
<%rs.Close
set rs=nothing%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--#include file= "foot.asp "-->
</body>
</html>
<script>
function regInput(obj, reg, inputStr)
{
var docSel= document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT ")return false
oSel = docSel.duplicate()
oSel.text = " "
var srcRange= obj.createTextRange()
oSel.setEndPoint( "StartToStart ", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
</script>
我点击掉交按钮后,说修改成功,然后自动跳回到修改页面~但里面的内容还是原来的~
各位好心的大哥大姐们,帮帮小弟!
不胜感激!谢谢了!!!!!!!!!!
[解决办法]
1,查下取值有没有真正取到值,会不会变量名有错误.
2,查下数据库字段的宽度设置和提交的值有没有不匹配的.
3,实在都不行,用update table set ...=...命令,在数据库里直接执行,看有没有错误提示.
[解决办法]
这种问题经常遇到的嘛,有可能是某个变量没有取得,写不进去
楼上说得差不多,可以用SQL语句update set来更新数据库,好好看一下是不是值没有取到
[解决办法]
跳转回来后刷新一下看看，你用的是history.go(-1);后退，页面上显示的数据应该还是修改以前的
[解决办法]
rs.Open "select payid,paypin,payurl,npayid,npaypin,npayurl,westid,westurl,ipayid,ipaypin,ipayurl,ypayid,ypaypin,ypayurl from webinfo ",conn,1,3
你的rs打开的是webinfo表的所有记录,应为没有 "where "条件.
那么不管你打算修改表中的哪一行数据,每次只能起到修改第一行数据的作用.
因为rs返回多行数据时,指针首先是指向第一行的,这时利用
rs( "paypin ")=trim(request( "paypin "))
是把每一行的paypin列的值给修改了.
建议改为:
rs.open "select * from webinfo where payid= "&rs( "payid ")
那么rs指向的只有你要修改的那一行.
