There are two reserved words in your query that will cause a problem. They are: Size and Delete, these column names should not be used.
Without knowing the values of your variables. I can't say for sure if this is your problem. ============================================ Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ============================================ -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:55 PM To: CF-Talk Subject: RE: Whats wrong with this code? No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: > Are all you column data types "text" ? > > ============================================ > Bryan F. Hogan > Director of Internet Development > Macromedia Certified ColdFusion MX Developer > Digital Bay Media, Inc. > 1-877-72DIGITAL > ============================================ > > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 27, 2003 2:43 PM > To: CF-Talk > Subject: Whats wrong with this code? > > > Hi, > > Whats wrong with the below code? I get a SQL syntax error. > > <cfquery name="qInsertData" DATASOURCE="databaser"> > INSERT INTO results ( > FileName, > Command, > CreatedOn, > LastAcc, > LastMod, > Size, > Directory, > Username, > New, > Copy, > Delete, > Move, > Rename, > Description > ) > VALUES ( > <cfqueryparam value="#Filename#" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="DELETE" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#DateFormat(FileDateCreated(TheFile), > 'mm/dd/yyyy')# - #TimeFormat(FileDateCreated(TheFile), 'HH:MM:SS')#" > cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#DateFormat(FileDateLastAccessed(TheFile), > 'mm/dd/yyyy')# at #TimeFormat(FileDateLastAccessed(TheFile), 'HH:MM:SS')#" > cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#DateFormat(FileDateLastModified(TheFile), > 'mm/dd/yyyy')# at #TimeFormat(FileDateLastModified(TheFile), 'HH:MM:SS')#" > cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#FileSize(TheFile)#" > cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#TheFolder#" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#auth#" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="NO" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="NO" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="YES" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="NO" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="NO" cfsqltype="CF_SQL_LONGVARCHAR">, > <cfqueryparam value="#FileSource# DELETED successfully from #DirPath#" > cfsqltype="CF_SQL_LONGVARCHAR"> > ) > </cfquery> > > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
