语法错误 (操作符丢失),,不知道错在哪了
<!--#include file=../include/open.asp--><%
dim waykind,name,keyword,NOD,vehicle,stardate,endDate,price0,price3,content,service,journey,is_show
waykind=replace(server.HTMLencode(request("waykind")),"'","''")
name=replace(server.HTMLencode(request("name")),"'","''")
keyword=replace(server.HTMLencode(request("keyword")),"'","''")
NOD=replace(server.HTMLencode(request("NOD")),"'","''")
vehicle=replace(server.HTMLencode(request("vehicle")),"'","''")
endDate=replace(server.HTMLencode(request("endDate")),"'","''")
price0=replace(server.HTMLencode(request("price0")),"'","''")
price3=replace(server.HTMLencode(request("price3")),"'","''")
content=replace(server.HTMLencode(request("content")),"'","''")
service=replace(server.HTMLencode(request("service")),"'","''")
journey=replace(server.HTMLencode(request("journey")),"'","''")
if content="" then
response.write "内容填写不完整<a href='insert.asp' target='_self'>返回</a>"
response.end
end if
is_show=true
sqlcmd="insert into wygkway (waykind,name,keyword,NOD,vehicle,stardate,endDate,price0,price3,content,service,journey,is_show) values ('"&waykind&"','"&name&"','"&keyword&"','"&NOD&"','"&vehicle&"','"&stardate&"','"&endDate&"','"&price0&"'，'"&price3&"'，'"&content&"'，'"&service&"'，'"&journey&"'，"&is_show&")"
conn.execute sqlcmd
conn.close
set conn=nothing
%>
下面是open.asp文件的代码
<%
set conn=server.createobject("adodb.connection")
dbpath=server.mappath("../database/#wygkcnly.mdb")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&dbpath&""
%>
运行的时候显示
Microsoft OLE DB Provider for ODBC Drivers '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 ''price0'，'price3'，'content'，'service'，''，True' 中。
\web\way\insert_action.asp, line 25
哪错了啊··
