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%>