请高手帮忙看下, SQL更新的问题.,多谢多谢
我在用COMMAND命令做SQL数据更新时出现不能更新,显示语法错误. 请大家帮我看下怎么回事.
错误类型:
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误。
<%
if(Session("MM_Username") <> "") then Command1__send_name = Session("MM_Username")
if(Session("Customerid") <> "") then Command1__send_id = Session("Customerid")
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_asd_STRING
Command1.CommandText = "UPDATE dingcanorders SET use_name = " + Replace(Command1__send_name, "'", "''") + " WHERE orderid = " + Replace(Command1__send_id, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
变量都传递过来了啊.