You are using a simple cfloop from to, instead of a cfquery or a cfloop query.
Because of this, when you call "#stockTable.stockTitle#", it defaults to the first line of the query. Either change your loop to a cfloop query="stockTable"> Or change your data call to "#stockTable.stockTitle[R]#" William -----Original Message----- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Saturday, April 23, 2011 9:45 AM To: cf-talk Subject: Problem Using QueryNew 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:343910 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
