如何把接收到的form的值存到database中，代码如下

[fan_ren]

sname=Request.Form("name")
sql="INSERT INTO table1(Name) VALUES(sname)"
conn.Execute sql
Response.Write(sname)
最后一样能正常运行，显示出sname的值，但是前面为什么得不到sname的值，说
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/practise/guestbook.asp, line 13

[ChinaOk]

sql="INSERT INTO table1(Name) VALUES('" & sname &"')"

[wangfei2428]

sql="insert into table1 (name) values ('"&name&"') "
conn.execute(sql)

[lbqlbq]

sql="insert into table1 (name) values ('"&sname&"') "
conn.execute sql

[popcode]

sql="insert into table1(name) values ('"&sname&"')"
conn execute (sql)

[cmsoft]

sname=Request.Form("name")
sql="INSERT INTO table1(Name) VALUES('"&sname&"')"
conn.Execute sql

[sichuanwww]

用 addnew,

[yemol_yuan]

sql="INSERT INTO table1(Name) VALUES('" & sname & "')"

[yemol_yuan]

马上就可以1000了

[ssm1226]

sql="INSERT INTO table1(Name) VALUES('"& sname &"')"


★★★一起去淋雨★★★