I don't think you'll be able to fetch it directly into a query with cfhttp unless you can put a value in those columns. The alternative would be fetch the content into the usual text string returned in the cfhttp content variable and parse the content once you have it down.
> No suggestions on this one? >> I am trying to extract data from a textfile database, >> using <CFHTTP>. >> The problem I am running into is that there are null >> fields in the >> textfile database and CFHTTP is then counting two fields >> as one (tab >> seperated). For example, in my textfile there will be >> something like >> this: >> >> field1 field2 field3 >> data data data >> data data >> data data data >> >> I am getting an Incorrect number of columns error, >> because coldfusion >> is missing the null field and counting only 2 fields for >> the second >> row of data. Has anyone else come accross this, or have >> any >> suggestions? I have considered using the replace >> function on the >> variable and replacing all double tabs with a >> tab<space>tab. But this >> to me seems like a poor work around. >> >> I am using <CFHTTP url="#pathtofile#" >> columns="field1,field2,field3" >> firstrowasheaders="yes" delimiter="tab"></CFHTTP> s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
