Nope... The #CreateODBCDateTime(Now())# did not help.
im starting to wonder about the possibility of a access violation....
I am doing two SQL inserts on two different databases in the same CF
file.... The first SQL insert works fine... it hits the second insert and
i error out.
The databases are both MS Access right now.
At 04:38 AM 11/27/00 -0500, you wrote:
>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
