机场路117医院有妇科吗:求助：ASP程序问题，更新失败，语法错误

来源：百度文库编辑：神马品牌网时间：2024/04/19 08:43:14

<%

if(Request("id") <> "") then Command1__send_id = Request("id")

%>
<%
Dim Recdetail__MMColParam
Recdetail__MMColParam = "1"
If (Request.QueryString("class_id") <> "") Then
Recdetail__MMColParam = Request.QueryString("class_id")
End If
%>
<%
Dim Recdetail
Dim Recdetail_numRows
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_titlename_STRING
Command1.CommandText = "UPDATE ftp SET count=count + 1 WHERE id =" + Replace(Command1__send_id, "'", "''") + ""
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>

Microsoft JET Database Engine 错误 '80040e14'

UPDATE 语句的语法错误。

/ftp/detail/jy3.asp，行37
第一位的不行啊。第二位的不知道怎么没有该项
说一下我的ID是数字型的

Command1.CommandText = "UPDATE ftp SET count=count + 1 WHERE id =" + Replace(Command1__send_id, "'", "''") + ""

修改这句试试...

Command1.CommandText = "UPDATE ftp SET count=count + 1 WHERE id =" & Replace(Command1__send_id, "'", "''")

不知道你的ID字段是数值型的还是字符型的..若是数值型的应改为..

Command1.CommandText = "UPDATE ftp SET count=count + 1 WHERE id =" & Command1__send_id

若为字符型,则..

Command1.CommandText = "UPDATE ftp SET count=count + 1 WHERE id ='" & Command1__send_id & "'"

也可能是你系统的问题，看看文件夹选项中的，取消“简单文件共享”

求助：ASP程序问题，更新失败，语法错误求助：ASP程序问题，更新失败，语法错误程序更新失败求助：程序正常初始化失败问题。求助：程序正常初始化失败问题。 asp语法错误 ASP语法错误 ASP的问题。user附近有语法错误？？语法错误,操作符丢失,ASP问题帮看下 ASP 新建站点失败求助？