My first time using created queries, I can't understand why this is putting the same value on every row.
<cfset stock = QueryNew("StockTitle, Varchar")> <cfoutput> <cfloop from="1" to="#stockTable.recordcount#" index="R"> <cfset newrow = QueryAddRow(stock,1)> <cfset temp = QuerySetCell(Stock, "stockTitle", "#stockTable.stockTitle#", R)> </cfloop> </cfoutput> <cfoutput query="stock"> #stock.stockTitle#<br /> </cfoutput> No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11 07:36:00 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm