The performance of cffile action="read" and cfloop list=file, delim=end of line
chars is terribly poor... Furthermore (as you have found out), there's usually
a lot of trial and error getting this to work.
Assuming you have a well-formatted delimited text file, the best approach is to
use CFHTTP:
<cfhttp
url="http://www.domain.com/urltotextfile/file.txt";
name="data"
columns="field1,field2,field3"
firstrowasheaders="false"
delimiter="|"
textQualifier="" />
OR if your first row does contain column headers:
<cfhttp
url="http://www.domain.com/urltotextfile/file.txt";
name="data"
firstrowasheaders="true"
delimiter="|"
textQualifier="" />
Both will result in a query object named 'data'.
Jake Pilgrim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284132
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
