提示错误：Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'Id ='. 是什么原
错误类型：
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'Id ='.
/web/fs/update.asp, 第 29 行
以下是update.asp文件
为什么会出现这个错误呢？
<!--#include file="inc/conn.asp" -->
<%
if(Request("name") <> "") then Command1__varname = Request("name")
if(Request("mobilphone") <> "") then Command1__varguestsex = Request("mobilphone")
if(Request("phone") <> "") then Command1__varguestage = Request("phone")
if(Request("fax") <> "") then Command1__varguestadress = Request("fax")
if(Request("email") <> "") then Command1__varpersonid = Request("email")
if(Request("qq") <> "") then Command1__varback = Request("qq")
if(Request("address") <> "") then Command1__varguestfather = Request("address")
if(Request("id") <> "") then Command1__varid = Request("id")
%>
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = conn
Command1.CommandText = "UPDATE show SET name='" + Replace(Command1__varname, "'", "''") + "', mobilphone='" + Replace(Command1__varmobilphone, "'", "''") + "', phone='" + Replace(Command1__varphone, "'", "''") + "', fax='" + Replace(Command1__varfax, "'", "''") + "', email='" + Replace(Command1__varemail, "'", "''") + "', qq='" + Replace(Command1__varqq, "'", "''") + "', address='" + Replace(Command1__varaddress, "'", "''") + "' WHERE Id = " + Replace(Command1__varid, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
Response.Redirect("Admin_pu_index.asp")
%>
问题点数：0、回复次数：2Top
1 楼TrueAndFalse（彩旗飘飘）回复于 2004-05-02 17:03:54 得分 0
id 的值没有传过来啊Top
2 楼s1ihome（My hometown is a beautiful village）回复于 2004-05-03 01:27:05 得分 0
语法错误,就是没有接受到id值啊Top
相关问题
- 一个有关计算n! , e , e的x次方
- 哪位有解f = a*x*x+b*y*y+c*x*y+d*x+e*y+g的代码啊？？？
- 如何复制MSSQL的DATABASE-从E文NT的到PWIN98的MSSQL
- 如何用Server.Mappath将“E:\bbs\database\data.mdb”换为相对路径
- x
- 菜鸟问题：怎么创建Database Device?偶的e文很烂，最好能详细一点！有例子！
- 请问在数学表达式中求e的x次方用什么函数啊？？？
- 谁知道数学函数ln（x）java里怎么表示吗，就是log已e为底的那个阿
- x=x&(x-1)
- 关于visual assist x在中文vc2003下syntax color 无法正常显示，请高人进来指点指点！
