Nevermind...it wasn't the fact the one of the fields in a row was empty in the text file, it was the fact that there were two empty rows, caused by returns, at the bottom of the file...
Rick > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Sunday, September 07, 2008 8:14 PM > To: CF-Talk > Subject: Problem with Empty Fields when using cfquery and load data infile > > Hi, all... > > Hope everyone's having a nice weekend. > > Can anyone tell me how to modify this query so that > I don't get an error when a row doesn't contain data > for all columns? > > Here's the query, using MySQL 5 load data infile syntax: > > <cfquery name="load_photos" datasource="xxx"> > > load data infile 'e:/active_photos.txt' > into table hmls_active_photos_temp > lines terminated by '\r\n' > ignore 1 lines > > </cfquery> > > I keep getting the error: > > "Row 26821 doesn't contain data for all columns. > > I need some kind of "ignore empty fields" or "set empty fields to null" > command. > > Suggestions? > > Thanks, > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
