请教各位高手,如何用命令将数据库中的一个时间更新为现在的时间

我是这么写的,高手帮我看看,该怎么写 <%

if(Request("zhutiID") <> "") then Command3__StrID = Request("zhutiID")

%> -------------------------------------------------------- <%

set Command3 = Server.CreateObject("ADODB.Command") Command3.ActiveConnection = MM_conn_STRING Command3.CommandText = "UPDATE zhuti SET time ="now()" WHERE zhutiID=" + Replace(Command3__StrID, "'", "''") + "" Command3.CommandType = 1 Command3.CommandTimeout = 0 Command3.Prepared = true Command3.Execute()

%> Microsoft VBScript 编译器错误 (0x800A0401) 语句未结束 /dwmx2004/web/reply-xx.asp, line 44, column 49 Command3.CommandText = "UPDATE zhuti SET time ="now()" WHERE zhutiID=" + Replace(Command3__StrID, "'", "''") + ""

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。 /dwmx2004/web/reply-xx.asp, 第 48 行