The CFHTTP URL seems missing "=" after "Symbols".
and you may want to make sure the values are in one line.
Also make sure the values of COLUMNS are in one line.
Hua
========================
<CFHTTP METHOD="GET"
URL=""> DC+AGNI&format=sl1d1t1c1ohgv&ext=.csv"
NAME="GetQuotes"
COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Chan
ge,Opening_Price,Days_High,Days_Low,Volume"
DELIMITER=","
TEXTQUALIFIER=""
charset="iso-8859-1"
TIMEOUT="400"
>
<CFDUMP var="#CFHTTP.Filecontent#">
<CFDUMP var="#GetQuotes#">
===============================
-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 12:28 PM
To: CF-Talk
Subject: CFHTTP GET CSV File problem ?
Everytime I call the following cfhttp snippet it always errors out
telling me 'Incorrect number of columns in row."
Please check the number of columns specified in the columns attribute
and in the target file.
I have 9 columns in the columns attribute and the target file contains 9
columns as well.
I can paste the link specifed in the cfhttp tag in a browser and it
returns a csv file with exactly 9 columns.
Is there any bugs in cfhttp?
<CFHTTP METHOD="GET"
URL=""> C+AG
NI&format=sl1d1t1c1ohgv&ext=.csv"
NAME="GetQuotes"
COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Chan
ge,O
pening_Price,Days_High,Days_Low,Volume"
DELIMITER=","
TEXTQUALIFIER=""
charset="iso-8859-1"
TIMEOUT="400"
proxyserver="xxx.xxx.xxx.xxx"
proxyport="xxxx">
<CFDUMP var="GetQuotes">
Regards,
Dave Bosky
HTC Disclaimer: The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
