高手帮我看一下,insert into 句子语法错误?

来源:百度知道 编辑:UC知道 时间:2024/06/04 19:14:55
sql="insert into [gift] (product,company,image,point,instruction) values ('"& product &"','"& company &"','"& filename &"','"& point &"','"& instruction &"')"

sql="insert into [gift] ([product],product,[company],company,[filename],image,[point],point,[instruction],instruction)"

不行的话,你看看这个,希望有启发
http://zhidao.baidu.com/question/3934916.html?fr=qrl3

sql="insert into [gift] values ('"& product &"','"& company &"','"& filename &"','"& point &"','"& instruction &"')"
应该是这样吧

<!-- #include file="../Connections/conn.asp" -->
<%
dim zhanghaoa,mimaa,mimab,sex,qq,mail
zhanghaoa= request.Form("zh")
mimaa = request.Form("mm")
mimab = request.Form("mma")
qq = request.Form("q")
mail = request.Form("m")
sex = request.Form("select")
t = now()'插入注册时间
set rs = con.execute