In Access, I don't think you can use Date as a field name. I used to have
lots of trouble with that when I used to use Access. I always made it
the_date or something.
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 1:49 PM
To: CF-Talk
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
