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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
