-----Original Message-----
From: Chris Stoner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 4:17 PM
To: CF-Talk
Subject: Re: OT - Stock App question
Try this, you forgot to specify a name for the query:
<cfhttp url="" "
method="GET"
name="qStockItems"
columns="Symbol,LastTradedPrice,LastTradedDate,LastTradedTime,Change,OpeningPrice,DaysHigh,DaysLow,Volume"
textqualifier='"'
delimiter=","
firstrowasheaders="no">
<cfdump var="#qStockItems#">
----- Original Message -----
From: Eric Creese
To: CF-Talk
Sent: Tuesday, January 27, 2004 4:33 PM
Subject: OT - Stock App question
I want to take the following and submit it to a database. how do you take the var values and parse through to insert into a database (SQLServer 2000)
<CFHTTP METHOD="GET"
URL="" "
COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Change,O
pening_Price,Days_High,Days_Low,Volume"
DELIMITER=","
TEXTQUALIFIER=""
>
<cfdump var="#CFHTTP.FileContent#">
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
