SQL语句菜鸟小错误_ 语法错误 (操作符丢失) 在查询表达式

zpwsz 2003-12-13 01:00:34

错误提示：
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
rosoft VBScript 编译器错误错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'zkpick.pickid =0 UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid =0' 中。

/web/show_1.asp，行27

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

源文件：

siteid=CLng(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open "Select * from zkpick where zkpick.pickid ="&siteid&" UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid ="&siteid,conn,1,3

...全文

59 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

银狐被占用 2004-03-26

打赏
举报

怎么把查询和更新写到一个里了？

改成：
rs.open "Select * from zkpick where zkpick.pickid ="&siteid ,conn,1,3

conn.execute "UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid ="&siteid

vvfish119 2004-03-26

打赏
举报

rs.open "Select * from zkpick where zkpick.pickid ="&siteid&" UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid ="&siteid,conn,1,3
这句到底是查询还是更改？？为什么两句在一起呢？
rs.open "UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid="&siteid,conn,1,3

jiank 2004-03-26

打赏
举报

dim strsql
siteid=CLng(request.querystring("id"))
strsql="UPDATE zkpick SET pickid=pickid+1 WHERE pickid="&siteid
application.lock
conn.execute(strsql)
application.unlock
set rs=server.createobject("adodb.recordset")
strsql="Select * from zkpick where pickid ="&siteid
rs.open strsql,conn,3,,1
……
rs.close:set rs=nothing
conn.close

seezoo 2004-03-26

打赏
举报

zpwsz 2003-12-13

打赏
举报

我按上面各位仁兄做　，都不行呀？！

lovehwq21 2003-12-13

打赏
举报

把两句拆开写啊
conn.Excute "UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid ="&siteid
rs.open "Select * from zkpick where zkpick.pickid ="&siteid&",conn,1,3

xiaoyuehen 2003-12-13

打赏
举报

rs.open "Select * from zkpick where zkpick.pickid ="&siteid&";UPDATE zkpick SET zkpick.pickid=zkpick.pickid+1 WHERE zkpick.pickid ="&siteid,conn,1,3

试试。