Why not use cffile and then load it into the db...then you could easily process the data to be however you want it?
Eric /*-----Original Message----- /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, September 17, 2008 7:40 PM /*To: CF-Talk /*Subject: Problem loading data from text file... /* /*I'm using this query to load data into a table from a text file: /* /*<cfquery name="load_data" datasource="c21ar"> /* /* load data infile /*'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_p /*hotos.txt' /* into table hmls_active_photos_temp /* lines terminated by '\r\n' /* ignore 1 lines /* /*</cfquery> /* /*It runs fine except for the fact that at the end of each day's new /*"active_photos.txt" file, /*there are a couple of blanks lines, like the <ENTER> key has been struck a /*couple of times /*after the last line of data. /* /*The load data infile command is trying to read these lines and throws an /*error because of the /*empty lines. /* /*Is there some way to cause this query not to process, or to skip, empty /*lines? The empty lines /*are always at the end of the file and prevent me from automating the /*loading of data. /* /*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:312747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
