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