UC知道语法错误 (操作符丢失) 在查询表达式 急！！！在线等
来源：百度知道 编辑：UC知道 时间：2024/04/28 07:04:38
错误类型：
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"))&"')"
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"))&"')"
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"))&"')"
你没加引号