I am attempting to loop trough a txt file and loop the
entries into a
database. The file is delimited by a pipe '|' but when I
attempt it, I get:
Incorrect number of columns in row.
Verify the number of columns specified in the columns
attribute and in the
target file
The error occurred in wwwroot\test.cfm Line 3
Line 3 being the cfhttpparam type="Header" name="TE", but if
I remove it, I
get an error in the main CFHTTP line (1).
After googling for a while I found a site that mentions that
if the file has
a carriage return, you can get this error. Is there a way to
remove the
carriage return or am I missing something else. Below is my
code for the
CFHTTP.
<cfhttp name="Property"
url="
http://www.bpoprosonline.com/assets/property/idxrs082607.txt"
delimiter="|" method="get">
<cfhttpparam type="Header" name="Accept-Encoding"
value="deflate;q=0">
<cfhttpparam type="Header" name="TE"
value="deflate;q=0">
</cfhttp>
If you want to see the file, you can use the URL link above
to link to my
sample txt file.
Thanks.
--
Wally Kolcz
MyNextPet.org
Founder / Developer
586.871.4126