怎么将这段插入数据的代码改成修改数据的代码？

[cougar]

sinto="insert into userinfo (username,password,question,ask,name,email,phone,fax,address,sex,age,education,employment,occupation,income,companyname,homepage,province,companysize)"
sinto=sinto&"values ('"
sinto=sinto&username&"','"
sinto=sinto&password&"','"
sinto=sinto&question&"','"
sinto=sinto&ask&"','"
sinto=sinto&name&"','"
sinto=sinto&email&"','"
sinto=sinto&phone&"','"
sinto=sinto&fax&"','"
sinto=sinto&address&"','"
sinto=sinto&sex&"','"
sinto=sinto&age&"','"
sinto=sinto&education&"','"
sinto=sinto&employment&"','"
sinto=sinto&occupation&"','"
sinto=sinto&income&"','"
sinto=sinto&companyname&"','"
sinto=sinto&homepage&"','"
sinto=sinto&province&"','"
sinto=sinto&companysize&"')"
my.execute(sinto) %>

[tripofdream]

Sqlupdate="update userinfo set username='" &username & "'," _
& "password='" & password & "'," _
........
& " where ......"

[cougar]

用这种方法改了后可以将值传递到下一页面中。但不能存到数据库中。
后面要加my.execute(Sqlupdate)，但出错.

[tripofdream]

>>将值传递到下一页面中?么意思?说清楚点

[cougar]

就是修改后出面一个修改成功的页面，在页面中显示修改后的数据。

[rickyfeng]

可能? ^_^