好象是要更改吧?可以这样的:
nSmid = Request.Form("smid")
set cn=server.CreateObject("adodb.connection")
cn.Open application("ConnectionString")
sqlstr = "update tablename set field="content u want to modify" where id=" & nsmid
cn.Execute (sqlstr)
cn.Close
set cn=nothing
Response.Redirect "kkk.asp