28,391
社区成员
发帖
与我相关
我的任务
分享
<%if request("action")=1 then
set rs=server.CreateObject("adodb.recordset")
sql="select * from xiangmu"
rs.open sql,conn,3,2
rs.addnew
rs("name")=trim(request("name"))
rs("jianjie")=trim(request("jianjie"))
rs("username")=trim(request("username"))
rs("usertime")=now()
rs.update
rs.movelast
rs.close
Set rs = CreateObject("adodb.recordset")
sql = "SELECT id FROM xiangmu oder by id desc"
rs.CursorLocation = 3
rs.Open sql, conn, 1, 1
id=rs("id")
id=id+1
Set rs1 = CreateObject("adodb.recordset")
sql1 = "SELECT id FROM xiangmu oder by id desc"
rs1.CursorLocation = 3
rs1.Open sql1, conn, 1,3
rs1.AddNew
rs1("name")=trim(request("name"))
rs1("jianjie")=trim(request("jianjie"))
rs1("bianhao")=id
rs1("id")=id
rs1.Update
rs1.close
rs.close
…………
rs.update
response.write(rs("ID"))
rs.close
response.end
先看看update之后能不能通过rs("ID")取值,以及ID和bianhao是不是数值型的,如果是字符型的应该用下面这个
conn.execute "update xiangmu set bianhao='" & replace(rs("ID"),"'","''") & "' where id='" & replace(rs("ID"),"'","''") & "'"
Set rs = CreateObject("adodb.recordset")
sql = "SELECT * FROM xiangmu WHERE 1=0"
rs.CursorLocation = 3
rs.Open sql, conn, 1, 3
rs.AddNew
rs("name")=trim(request("name"))
rs("jianjie")=trim(request("jianjie"))
bk = rs.Bookmark
rs.Update
rs.Bookmark = bk
id = rs("id")
rs("bianhao") = id
rs.Update
rs.close
您看是否方便再帮我研究一下,谢谢
<%if request("action")=1 then
set rs=server.CreateObject("adodb.recordset")
sql="select * from xiangmu"
rs.open sql,conn,3,2
rs.addnew
rs("name")=trim(request("name"))
rs("jianjie")=trim(request("jianjie"))
rs("username")=trim(request("username"))
rs("usertime")=now()
rs.update
conn.execute "update xiangmu set bianhao=" & rs("ID") & " where id=" & rs("ID")
rs.close
Set rs = CreateObject("adodb.recordset")
sql = "SELECT * FROM xiangmu WHERE 1=0"
rs.CursorLocation = 3
rs.Open sql, conn, 1, 3
rs.AddNew
rs("name") = trim(request("name"))
rs("jianjie") = trim(request("jianjie"))
rs("username") = trim(request("username"))
rs("usertime") = Now()
bk = rs.Bookmark
rs.Update
rs.Bookmark = bk
id = rs(id)
rs('xxxx') = id
rs.Update
rs.close