You're getting the numeric index, rather than the currency value. Try this,
assuming that the database has columns like 'product_price_eur'.
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);
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:320897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4