一生简童:求助:ASP程序问题,更新失败,语法错误
来源:百度文库 编辑:神马品牌网 时间:2024/04/27 13:10:17
<%
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是数字型的
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
这一句给 count加上中括号 [] 建议id也加上 []这样就可以跟系统变量区别开
Command1.CommandText = "UPDATE [ftp] SET [count]=[count] + 1 WHERE [id] =" + Replace
count 是保留关键字 换其他变量