Now I remember, I dad the same problem...CF allowed me to READ from a field
called DATE, but not INSERT to it. I changed the field to dateX and it
worked fine.
----- Original Message -----
From: Todd Ashworth <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 2:09 PM
Subject: Re: INSERT into error....
> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
