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

晕，这也叫难，
rs("time")=now()

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

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, "'", "''") + ""

"UPDATE zhuti  SET time ="&amp;now()&amp;" WHERE zhutiID=" &amp; Replace(Command3__StrID, "'", "''")

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

"UPDATE zhuti  SET [time] =now WHERE zhutiID=" &amp; Replace(Command3__StrID, "'", "''")

最好不要用time,name,password等关键字作字段名，如果用的话用[]括起来

"UPDATE zhuti SET time ='"&now()&"' WHERE zhutiID=" & Replace(Command3__StrID, "'", "''") 时间好像得用'号扩起来比如"UPDATE zhuti SET time ='2005-10-22 22:15' WHERE zhutiID=" & Replace(Command3__StrID, "'", "''") 应该是得用单引号，或者最安全的方法就是用RecordSet来修改。 根据楼主的代码可以改为: Dim rsUp Set rsUp=Server.CreateObject("ADODB.RecordSet") rsUp.Open "select * From zhuti WHERE zhutiID=" & Replace(Command3__StrID, "'", "''") ,MM_conn_STRING,1,3 rsUp.Fields("time").Value=now() rsUp.Update rsUp.Close Set rsUp=Nothing 这样起码保证应该不会出错误。

"UPDATE zhuti  SET time =#2005-10-22 22:15# WHERE zhutiID=" &amp; Replace(Command3__StrID, "'", "''")

时间应该是这样吧