注册 登录
编程论坛 ASP技术论坛

语法错误 (操作符丢失),,不知道错在哪了

az285002 发布于 2008-11-03 16:02, 1173 次点击
<!--#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
哪错了啊··
5 回复
#2
madpbpl2008-11-03 16:22
"&is_show&"
改成
'"&is_show&"'
试试
#3
az2850022008-11-03 17:22
按照楼上的说法更改之后变成

没有为命令对象设置命令。
\web\way\insert_action.asp, line 25
#4
lili06102008-11-03 17:44
我只能说一点,如果有时间的话,给改成这样,再写入到ACCESS数据库.
#day#
#5
yms1232008-11-03 17:54
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
最少错误的添加方法
Set rsInsW=Server.CreateObject("ADODB.RecordSet")
rsIns.Open "select * from wygkway",conn,1,3
rsIns.AddNew
rsIns("waykind")=waykind
rsIns("name")=name
rsIns("keyword")=keyword
rsIns("NOD")=NOD
rsIns("vehicle")=vehicle
rsIns("stardate")=stardate
rsIns("endDate")=endDate
rsIns("price0")=price0
rsIns("price3")=price3
rsIns("content")=content
rsIns("service")=service
rsIns("journey")=journey
rsIns("is_show")=is_show
rsIns.Update
rsIns.Close
Set rsIns=Nothing
#6
az2850022008-11-05 11:49
解决了,谢谢大家
1