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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists