Syntax error when trying to update date/time field

[hazalj]

I am getting a MS Access ODBC Syntax error (missing operator) in query
expression '2006-01-05 09:17:01.0' when I try to execute an update query. On
the update form I have a hidden value that passes the current date and time.
Any help would be appreciated. Thanks. Here's the query:



<cfquery datasource="hazblog">
Update blog
set btitle='#btitle#', blogusersid='#blogusersid#', bcontent='#bcontent#',
bdate=#bdate#, fname='#fname#', lname='#lname#', category='#category#',
publish='#publish#', lastupdated=#lastupdated#
where blogid= #blogid#
</cfquery>

[hazalj]

Nevermind...got it.

[metasaad]

5 years later...I am getting the same problem, can you clarify how you fixed this?
Syntax error (missing operator) in query expression ''{ts '2006-01-28 11:40:17'}''

Many thanks!

S

[The ScareCrow]

As the OP may not be around any more:

You may need to post some code.

But try wrapping the value in createodbcdatetime

Ken