> Grouping in SQL does a different thing to grouping in cfoutput. What > are you trying to acheive? >
Thanks James. I just need a ready-to-use value list of the prices for skus. Let's say I have a ProductID 1. ProductID 1 has 3 SKUID's associated with it: 6,7,8 Those SKUS have prices: 6-5.99, 7-6.99, 8-9.99 When I query for the productmaster.cfm display page, I have quite a few different productID's. The query returns many SKUS associated with each product. The problem I'm having is displaying each product, with its respective SKU info (prices to be exact). Currently, I'm using <cfoutput query="getproducts" group="prodID"> and it works. But I can't figure out how to show the sku info correctly. I'm thinking if everything were grouped right in the SQL to start with, I wouldn't have these problems. Thanks much, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226360 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
