Yeah - it's odd that a cfhttp get on a txt file can yield a query object, but not on a csv file.
Perhaps the simplest solution would be to make a copy of the file with a txt extension, then cfhttp get it. The auto-conversion of txt data to a query is so darn handy, that little extra step is probably worth it. - Dave >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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
