Try #CreateODBCDateTime(Now())# instead of Now()
----- Original Message -----
From: Chad Gray <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 4:48 PM
Subject: INSERT into error....
> I think i have lost my mind... can anyone see the syntax error in my
> CFQUERY? The Table name, and field names are spelled correct. None of
the
> columns im inserting into are The primary key. (the file.clientfile is
> from a CFFILE command) The values in the error message are correct.
>
> Im about to pull my hair out. :)
>
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
> SQL = "INSERT INTO JobInfo(JobNum,LoginID,Date,FileName) VALUES( 6723, 1,
> {ts '2000-11-27 16:47:31'},'calendar.PDF' )"
> Data Source = "CJM.mdb"
>
>
>
> <cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC">
> INSERT INTO JobInfo(JobNum,LoginID,Date,FileName)
> VALUES(
> <cfoutput query="maxjobnum">#NEXTJOBNUM#,</cfoutput>
> <cfoutput query="getuploaddir">#loginID#,</cfoutput>
> <cfoutput>#now()#,</cfoutput>
> <cfoutput>'#File.ClientFile#'</cfoutput>
> )
> </cfquery>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
