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_photos.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:312730
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
