You do not need the evaluate functions, I would do something like: Variables["product_price_#c#"] = getProduct["product_price_#c#"][1];
The one being the placement in the query, I am just assuming it will return only one row and always one row and that is all you care to reference. On Tue, Mar 24, 2009 at 10:18 PM, Mike Little <[email protected]>wrote: > > ok, for... > > for (i=1; i LTE listLen(currencies); i=i+1) { > c = listGetAt(currencies, i); > product_price_"#c#" = evaluate('getProduct.product_price_' & c); > product_price_sale_"#c#" = evaluate('getProduct.product_price_sale_' & c); > } > > i still get... > > ColdFusion was looking at the following text: > \" > > The CFML compiler was processing: > > A script statement beginning with product_price_ on line 98, column 2. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
