Can you spot the syntax error?

[Roderick Rutlidge]

<cfquery datasource="#VARIABLES.Datasource#">
INSERT INTO Blogs (
Subject, DateTime, Body, UserName)
VALUES (
'#Form.Subject#', <CFQUERYPARAM CFSQLTYPE="CF_SQL_TIMESTAMP"
VALUE="#DateFormat(Now())# #TimeFormat(Now())#">,
'#Form.Body#',
'#VARIABLES.UserID#')</cfquery>

Why is this throwing a syntax error?

[allen@oysterweb.com]

What exactly is the error? When debugging is on, is there any more
details.

One item that jumps out is the DateTime field. Try using
#CreateODBCdatetime(Now())# instead.

[Roderick Rutlidge]

<allen@oysterweb.com> wrote in message
news:1128011017.446435.114670@g49g2000cwa.googlegr oups.com...

> What exactly is the error? When debugging is on, is there any more
> details.
>
> One item that jumps out is the DateTime field. Try using
> #CreateODBCdatetime(Now())# instead.
>

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in INSERT INTO statement. The error occurred
in C:\CFusionMX\wwwroot\site\blog\submitentry.cfm: line 14

12 : INSERT INTO Blogs (Subject,DateTime,Body,UserName)
13 : VALUES
14 : ('#Form.Subject#',<CFQUERYPARAM CFSQLTYPE="CF_SQL_TIMESTAMP"
VALUE="#DateFormat(Now())#
#TimeFormat(Now())#">,'#Form.Body#','#VARIABLES.Us erID#')
15 : </cfquery>
16 : our blog has been successfully submitted. To view or edit any of your
entries, <a href="editentries.cfm">click here</a>.

--------------------------------------------------------------------------------
SQL INSERT INTO Blogs (Subject,DateTime,Body,UserName) VALUES
('test', (param 1) ,'test','test')
DATASOURCE blog
VENDORERRORCODE -3502
SQLSTATE 42000

[Roderick Rutlidge]

<allen@oysterweb.com> wrote in message
news:1128011017.446435.114670@g49g2000cwa.googlegr oups.com...

> What exactly is the error? When debugging is on, is there any more
> details.
>
> One item that jumps out is the DateTime field. Try using
> #CreateODBCdatetime(Now())# instead.
>

Nevermind, problem solved. DateTime is a reserved word. Special thanks to
Bob Dively from alt.comp.lang.coldfusion