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> David Critchley ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205713 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
