See if this works.
<cfquery name="addtoCJM"
datasource="CJM.mdb"
dbtype="ODBC">
INSERT INTO JobInfo(JobNum,
LoginID,
Date,
FileName)
VALUES(#maxjobnum.NEXTJOBNUM#,
#getuploaddir.loginID#,
#createodbcdate(now())#,
'#File.ClientFile#')
</cfquery>
----- Original Message -----
From: Greg Wolfinger <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 1:38 AM
Subject: Re: INSERT into error....
> 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/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
