ASP INSERT INTO语句语法错误!
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--#include file="../conn.asp"-->
<%
dim sql
dim pname
dim cid
dim imagepath
dim ptype
dim describe
dim particularInfo
dim particularInfoUrl
pname=request.Form("pname")
cid=request.Form("cid")
imagepath=request.Form("imagepath")
if imagepath<>"" then
imagepath="images/"+imagepath
end if
ptype=request.Form("ptype")
describe=request.Form("describe")
particularInfo=request.Form("particularInfo")
particularInfoUrl="txt/"+cid+ptype+".txt"
'set fso=Server.CreateObject("Scripting.FileSystemObject")
'set txtFile=fso.CreateTextFile(Server.MapPath("../../product/txt/"+cid+ptype+".txt"),true)
'txtFile.Write(particularInfo)
'txtFile.close
sql="insert into productinfo(cid,ptype,pname,imagepath,describe,particularInfo) values("&cid&",'"&ptype&"','"&pname&"','"&imagepath&"','"&describe&"','"&particularInfoUrl&"')"
'Response.Write(sql)
conn.execute(sql)
Response.Write("添加商品信息成功!")
Response.Write("<a href='addproduct.asp' style='text-decoration:none;font-size:12px;'>继续添加</a>")
Response.Write("<a href='allproduct.asp'>返回商品信息首页</a>")
%>
各位大侠帮忙看看,看了网上的很多解决方法,但一直都还没有解决,很急啊。。。。。