关于ASP保存记录到access里无法保存??

来源:百度知道 编辑:UC知道 时间:2024/06/19 19:36:52
<!--#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

%>

上面是我写的保存代码

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