关于ASP保存记录到access里无法保存??
来源:百度知道 编辑:UC知道 时间:2024/09/20 13:32:35
<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<!--#include file="function.asp"-->
<!--#include file="char.inc"-->
<%
REQS=ChkRequest(Request.QueryString("QSID"),1) '防注入
'REQS = Request.QueryString("QSID")
data1 = Request("dwname")
data2 = Request("reviewname")
data3 = Request("review1")
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from E_QS where(ID is null)"
rs.Open rs.Source,conn,1,1
rs.addnew
rs("SpecialID")=CInt(REQS)
rs("DanWei")=data1
rs("XinMing")=data2
rs("QianShou")=data3
rs("Date")=getdate()
rs.close
set rs=nothing
response.redirect "Special_News.asp?SpecialID="&REQS
%>
上面是我写的保存代码
<!--#include file="config.asp"-->
<!--#include file="function.asp"-->
<!--#include file="char.inc"-->
<%
REQS=ChkRequest(Request.QueryString("QSID"),1) '防注入
'REQS = Request.QueryString("QSID")
data1 = Request("dwname")
data2 = Request("reviewname")
data3 = Request("review1")
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from E_QS where(ID is null)"
rs.Open rs.Source,conn,1,1
rs.addnew
rs("SpecialID")=CInt(REQS)
rs("DanWei")=data1
rs("XinMing")=data2
rs("QianShou")=data3
rs("Date")=getdate()
rs.close
set rs=nothing
response.redirect "Special_News.asp?SpecialID="&REQS
%>
上面是我写的保存代码
rs.Open rs.Source,conn,1,1
关键是这句,改成rs.Open rs.Source,conn,1,3即可
rs.Source="select * from E_QS where(ID is null)"
这句可以这样rs.Source="select * from E_QS"
你应该把引导页的代码也放上去
rs.Open rs.Source,conn,1,3
rs.addnew
rs("SpecialID")=CInt(REQS)
rs("DanWei")=data1
rs("XinMing")=data2
rs("QianShou")=data3
rs("Date")=getdate()
rs.update()
rs.close
set rs=nothing