I have a text field in my DB of type text that contains a product description. This is creating HUGE problems with queries as I can't use DISTINCT or GROUP BY on this field. Is there any way arround this?
For example if I want to select for a product details page... SELECT sum(t1.stock) AS TotalStock, t2.Description I can't do it, the query requires a group by on the description field but since it is a text type I cant use it in a group by... -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
