小问题???

[what_004]

数据表STU有两个字段user和id
当调用SQL=select * from STU where id=1，返回记录后
如何把user的值写进id=1对应的记录的user字段中(用user替换原来的user,id不变)
sql语句该如何写???

[tokilcoom]

update就可以了
sql="update 表 set user='"&user&"' where id=1

[若白师妹]

1.SQL=select * from STU where id=1
rs.open sql,conn,1,3
rs("user")=新user
rs.update
rs.close

2.sql="update stu set [user]='"& user &"' where id=1"
conn.execute sql

[tokilcoom]

user1=request.form("user1")
set conn=.....
conn.open "...."
sql="update stu set user(字段)='"+user1+"'where id=1"
conn.execute sql
conn.close
set conn=nothing