CF follow up to my previous post. I can't get the values of my DISTINCT query spit out correctly. In SQL Enterprise Manger I get the results I want which are ...
Query: <cfquery name="rsContestwinners" datasource="#datasource#"> SELECT DISTINCT YEAR(recw_assign_month) AS Expr_Year, MONTH(recw_assign_month) AS Expr_Month FROM dbo.tbl_recipe_monthly_winner WHERE (recw_assign_month <> '') ORDER BY Expr_Year, Expr_Month </cfquery> SQL Enterprise Manger Results: Expr_Year Expr_month 2005 1 2006 2 2006 4 2006 6 2006 7 2006 8 2006 9 2006 11 2001 1 CFOUTPUT ... <cfoutput query="rsContestwinners"> #trim(dateformat((Expr_month), "MMMM"))# #trim(Expr_year)# </cfoutput> gives me ... December 2005 December 2006 January 2006 January 2006 January 2006 January 2006 Thanks D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:266800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
