asp取得新插入记录的ID
- http://blog.gufang.org/
- 2015/7/20 16:42:45
- 来源:Gufang's Private Space
- 点击:
ACCESS库可以这样书写: <%
Set rs = server.CreateObject("adodb.recordset")
sql = "select * from table
rs.addnew
rs("title") = "title"
rs("content") = "content"
rs.update
newid = rs("id")
rs.Close
Set rs = Nothing
%>
SQLSERVER用上面的方法不行,必须在UPDATE后多加一句,rs.movelast.
<%
Set rs = server.CreateObject("adodb.recordset")
sql = "select * from table
rs.addnew
rs("title") = "title"
rs("content") = "content"
rs.update
rs.movelast
newid = rs("id")
rs.Close
Set rs = Nothing
%>
Set rs = server.CreateObject("adodb.recordset")
sql = "select * from table
rs.addnew
rs("title") = "title"
rs("content") = "content"
rs.update
newid = rs("id")
rs.Close
Set rs = Nothing
%>
SQLSERVER用上面的方法不行,必须在UPDATE后多加一句,rs.movelast.
<%
Set rs = server.CreateObject("adodb.recordset")
sql = "select * from table
rs.addnew
rs("title") = "title"
rs("content") = "content"
rs.update
rs.movelast
newid = rs("id")
rs.Close
Set rs = Nothing
%>
发表评论(0)