读书人

asp+access 保存数据有关问题

发布时间: 2012-04-11 17:42:33 作者: rapoo

asp+access 保存数据问题

VB code
set rs=server.createobject("adodb.recordset")      sql="select * from t_news"    rs.open sql,conn,3,3    rs.addnew         '添加记录到数据表末端     rs("title")    =    Request("title")  rs("content")    =    Request.Form("editor1")  rs("logtime") = now    rs.update         '更新数据表记录    rs.close    set rs=nothing


我这段代码,怎么不能保存到access中呢


[解决办法]
conn打开了吗?
VBScript code
<%set conn = CreateObject("ADODB.Connection")conn.Open "....."set rs = createobject("adodb.recordset") rs.CursorLocation = 3sql = "select * from t_news where 1=0"rs.open sql,conn,1,3rs.addnew rs("title") = Request("title")rs("content") = Request("editor1")rs("logtime") = now()rs.updaters.closeset rs = nothingconn.closeset conn = nothing%> 

读书人网 >ASP

热点推荐