Try this:
<cfoutput query="rsContestwinners">
#trim(Expr_year)# #trim(Expr_month)#<br>
</cfoutput>
I don't see any reason why you'd be getting a line break in the middle.
This code should display everything exactly like in Enterprise Manager.
The dateformat was changing the number to the month name. I'm not sure
if that's what you wanted.
-Jake
[EMAIL PROTECTED] wrote:
> 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:266813
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
