Is the "date" field name a reserved word? Try changing that to something
besides date.
What is the full error message?
Todd Ashworth
----- 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
