RE: OT - Stock App question

[Eric Creese]

here is something interesting, I go this to process however it did not error out, but did not put any data in the table. everything was NULL?


what did I miss???


<cfquery name="getsym" datasource="stocks">
SELECT sym FROM symbols WHERE exchg ='NYSE'
</cfquery>


<CFLOOP query="getsym">


<CFHTTP METHOD="GET"
URL="" #getsym.sym#&format=sl1d1t1c1ohgv&ext=.csv">http://quote.yahoo.com/download/quotes.csv?Symbols=<cfoutput>#getsym.sym#</cfoutput>&format=sl1d1t1c1ohgv&ext=.csv "
COLUMNS="Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Change,Opening_Price,Days_High,Days_Low,Volume"
DELIMITER=","
TEXTQUALIFIER=""
name="qStockItems"


>
<cfdump var="#CFHTTP.FileContent#">
<!--- Like to insert the dump here --->


<CFIF qStockItems.Last_Traded_Price NEQ 0.00>
    <cfquery name="Inssym" datasource="stocks">
INSERT INTO stocks
(Symbol,Last_Traded_Price,Last_Traded_Date,Last_Traded_Time,Change,Opening_Price,Days_High,Days_Low,Volume)
VALUES
('#qStockItems.Symbol#','#qStockItems.Last_Traded_Price#','#qStockItems.Last_Traded_Date#','#qStockItems.Last_Traded_Time#','#qStockItems.Change#','#qStockItems.Opening_Price#','#qStockItems.Days_High#','#qStockItems.Days_Low#','#qStockItems.Volume#')
    </cfquery>
</cfif>


<br>
</cfloop>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---