> Why do I get 36 records in my query when there should only be > 8? I must be doing something wrong with the AddRow and SetCell??? > > ... > > <cfloop from="1" to="#listLen(URL.SKUList)#" index="i"> > <cfscript> > QueryAddRow(getSKUs, #variables.i#); > ...
The second, optional argument for QueryAddRow specifies the number of rows to add, not what the position of the added row should be. On the first iteration of the loop, this will add one row to your query. On the second iteration, it'll add two, and so on. If you only want to add one row, omit the second argument of QueryAddRow. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
