CFMX 6.1/Access 2002 Date/Time Errors on INSERTStatement

[MazTaim]

The attached code gives me the following error:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.

I have tried numerous things including formatting the date/time, but I
continually get this error message. I am not sure if it is specific to the
date/time issue, but I am extremely stumped at this point. Any help would be
appreciated.



Code:


<cfquery name="CSDSurveyCMSubmit" datasource="hd0_csd">
INSERT INTO FollowUp (
Comment,
FollowBy,
Ticket,
Date,
Complete
)

VALUES (
'#Comment#',
'#Name#',
'#TicketNo#',
'#CreateODBCDateTime(now())#',
'1'
);
</cfquery>

[mxstu]

Two initial problems

1) "Date" is a reserved word and should not be used as a column name. Change
the column name to something else
2) Don't use single quotes around the #CreateODBCDateTime()# function.

Though I *think* #now()# and #CreateODBCDateTime()# return the same value.

[mxstu]

Ooops! What I meant was, I think #now()# returns the date/time in the same format as #CreateODBCDateTime()#

{ts '2005-08-01 08:42:34'}

[MazTaim]

That worked. Thank you for the help.