<cfparam name="URL.ArticleId" default="1">
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "modify">
<cfquery datasource="test" username="mjzheng" password="horseson">
UPDATE Article SET ChannelId=
<cfif IsDefined("FORM.channel") AND #FORM.channel# NEQ "">
#FORM.channel#
<cfelse>
NULL
</cfif>
, Title=
<cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">
'#FORM.title#'
<cfelse>
NULL
</cfif>
, SubTitle=
<cfif IsDefined("FORM.subtitle") AND #FORM.subtitle# NEQ "">
'#FORM.subtitle#'
<cfelse>
NULL
</cfif>
, Keywords=
<cfif IsDefined("FORM.keywords") AND #FORM.keywords# NEQ "">
'#FORM.keywords#'
<cfelse>
NULL
</cfif>
, Abstract=
<cfif IsDefined("FORM.abstract") AND #FORM.abstract# NEQ "">
'#FORM.abstract#'
<cfelse>
NULL
</cfif>
, Content=
<cfif IsDefined("FORM.contect") AND #FORM.contect# NEQ "">
'#FORM.contect#'
<cfelse>
NULL
</cfif>
, Source=
<cfif IsDefined("FORM.source") AND #FORM.source# NEQ "">
'#FORM.source#'
<cfelse>
NULL
</cfif>
, Author=
<cfif IsDefined("FORM.author") AND #FORM.author# NEQ "">
'#FORM.author#'
<cfelse>
NULL
</cfif>
, CreateTime=
<cfif IsDefined("FORM.createtime") AND #FORM.createtime# NEQ "">
#FORM.createtime#
<cfelse>
NULL
</cfif>
, AffairTime=
<cfif IsDefined("FORM.affairtime") AND #FORM.affairtime# NEQ "">
#FORM.affairtime#
<cfelse>
NULL
</cfif>
, UpdateTime=
<cfif IsDefined("FORM.updatetime") AND #FORM.updatetime# NEQ "">
#FORM.updatetime#
<cfelse>
NULL
</cfif>
, IsOnTop=
<cfif IsDefined("FORM.isontop") AND #FORM.isontop# NEQ "">
#FORM.isontop#
<cfelse>
NULL
</cfif>
, IsOnHomepage=
<cfif IsDefined("FORM.isonhomepage") AND #FORM.isonhomepage# NEQ "">
#FORM.isonhomepage#
<cfelse>
NULL
</cfif>
, IsOnRecommend=
<cfif IsDefined("FORM.isonrecommend") AND #FORM.isonrecommend# NEQ "">
#FORM.isonrecommend#
<cfelse>
NULL
</cfif>
, PublishStatus=
<cfif IsDefined("FORM.publishstatus") AND #FORM.publishstatus# NEQ "">
#FORM.publishstatus#
<cfelse>
NULL
</cfif>
, FamilyStatus=
<cfif IsDefined("FORM.familystatus") AND #FORM.familystatus# NEQ "">
#FORM.familystatus#
<cfelse>
NULL
</cfif>
WHERE ArticleId=#FORM.artitclid#
</cfquery>
<cflocation url="#CurrentPage#?#CGI.QUERY_STRING#">
</cfif>
<cfquery name="Recordset1" datasource="test" username="mjzheng" password="horseson">
SELECT *
FROM Article
WHERE ArticleId = #URL.Id#
</cfquery>


提示的出错信息是:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '2003-08-20 10:18:20.0' 中


请各位达人帮俺看看代码是那里错了?日期那里不知道怎么回事儿?

可能是日期格式那块出错了，我是从数据库中读出来，然后修改后再写入进去，这个时候就发生了格式不对的情况，这个地方难道需要转换吗？不是很明白，找个明白人解答！！

怎么把JDBC日期格式转换为ODBC日期呢？？？

'2003-08-20 10:18:20.0'

Access 要用 #

#2003-08-20 10:18:20.0#