I need to pull data from a remote CSV file and the way I see it I have 2 options.
1) Use CFHTTP to load it directly into a query variable. 2) Use CFHTTP to download the file and then CFQUERY it to get the data. The CSV file is returned as an attachment not directly as part of the body text, this is making CFHTTP fail to load the data into a query so option one seems a non starter. Option two is giving me problems as CF isn't releasing its lock on the file fast enough so the CFQUERY is failing. Anyone any other ideas? -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.17.1/1181 - Release Date: 11/12/2007 17:05 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
