When reading a CSV file with CFHTTP that contains a Byte Order Marker is is not correctly parsed. This leads to very confusing error messages. If I upload a csv file with the following first row and including the BOM...
Then on reading this file with CFHTTP with firstrowasheaders enabled it will throw the following error if I refer to the "title" column.
column [Title] not found in query, columns are [TITLE,SUPPLIERREF,END PREORDER WINDOW,PRE-ORDERS]
Which is obviously confusing.