Question

INSERT INTO 语句的语法错误 asp+access 急

错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/admin/addproducts.asp, 第 179 行
POST Data:
sclassid=1&pid=adm&pName=adm&price=0&spic=pro%2Fep.png&bpic=pro%2Fep.png&item1=&item2=&item3=&item4=&item5=&item6=&item14=&item7=&item15=&item8=&item9=&item10=&item11=&item12=&item13=&Hits=0&font=%D7% . . .

修改商品基本信息不报错 但在新增（插入）商品基本信息的时候会报出INSERT INTO 语句的语法错误。
以下为第179行：
conn.execute("insert into products (pid,pname,price,spic,bpic,content,userid,sclassid,elite,isuser,hits,item1,item2,item3,item4,item5,item6,item7,item8,item9,item10,item11,item12,item13,item14,item15) values('"&pid&"','"&pname&"','"&price&"','"&spic&"','"&bpic&"','"&content&"',"&userid&","&sclassid&","&elite&","&isuser&","&hits&","&item1&","&item2&","&item3&","&item4&","&item5&","&item6&","&item7&","&item8&","&item9&","&item10&","&item11&","&item12&","&item13&","&item14&","&item15&")")
response.Write("<script>alert('添加成功！');location='addproducts.asp?Sclassid="&sclassid&"'</script>")

请各位大侠帮忙修正？

Answer 1

conn.execute("insert into products (pid,pname,price,spic,bpic,content,userid,sclassid,elite,isuser,hits,item1,item2,item3,item4,item5,item6,item7,item8,item9,item10,item11,item12,item13,item14,item15) values('"&pid&"','"&pname&"','"&price&"','"&spic&"','"&bpic&"','"&content&"',"&userid&","&sclassid&","&elite&","&isuser&","&hits&",'"&item1&"','"&item2&"','"&item3&"','"&item4&"','"&item5&"','"&item6&"','"&item7&"','"&item8&"','"&item9&"','"&item10&"','"&item11&"','"&item12&"','"&item13&"','"&item14&"','"&item15&"')")

主要是字符串得用单引号扩起来