Yes! That was it. I changed the field names and it workds great. Thanks
On Thu, 27 Feb 2003 15:06:38 -0500, Bryan F. Hogan wrote: > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
