Question

语法错误 (操作符丢失) 在查询表达式 急！！！在线等

错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 '<P><FONT face=Verdana>You are bidding 500k GW Gold in Guild Wars<BR>Delivery Time:</FONT></P> <P><FONT face=Verdana>Usually we will log in game and send you an ingame tell and do the delivery within 5 minutes  since paypal payment received. So pleas' 中。
select case action
case "add"
For i = 1 To Request.Form("detail").Count
strDetail = strDetail & Request.Form("detail")(i)
Next
sql="Insert into product(name,price2,spic,categoryid,detail,recommend) values('"&trim(request.form("name"))&"',"&trim(request.form("price2"))&",'"&trim(request.form("spic"))&"',"&trim(request.form("categoryid"))&","&strDetail&",'"&trim(request.form("recommend"))&"')"
'response.write sql
'response.end
conn.execute(sql) 出错行
response.Write "<script language=javascript>alert('添加成功！');history.go(-1);</script>"
response.End

Answer 1

sql="Insert into product(name,price2,spic,categoryid,detail,recommend) values('"&trim(request.form("name"))&"',"&trim(request.form("price2"))&",'"&trim(request.form("spic"))&"',"&trim(request.form("categoryid"))&",'"&strDetail&"','"&trim(request.form("recommend"))&"')"

你没加引号