It also occurred to me that you could probably update your mime type for csv files on your web server and register it as plain text. That might work, and would eliminate the need to copy the file to a .txt file first.
>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
