if request("save")="save" then
username=request("username")
password=request("password")
'判断保存
set rs=server.createobject("adodb.recordset")
'sql="select * from db where id="&clng(request("id"))
sql="update db set username='"&username&"',password='"&password&"' where id="&clng(request("id"))
' rs.open sql,conn,1,3
' rs("username")=username
' rs("password")=password
conn.execute(sql)
rs.Update
rs.Close
set rs=nothing
if request("save")="save" then
username=request("username")
password=request("password")
'判断保存
set rs=server.createobject("adodb.recordset")
sql="select * from db where id="&clng(request("id"))
'conn.execute (sql)
rs.open sql,conn,1,3
rs("username")=username
rs("password")=password
rs.Update
rs.Close
set rs=nothing
conn.close
set conn=nothing
例如:
if request("save")="save" then
username=request("username")
password=request("password")
'判断保存
sql="select * from db where id="&request("id")
'conn.execute (sql)
rs.open sql,conn,1,3