Just an update as I'm continuing to research. . . it seems to be any user
"created column", not just case statments.
For example the following query also pads one space on the end of each
"created" column. . .
<cfquery name="test" datasource="#dataSource#">
SELECT '0' as level,
'Runs Total' as name,
'NYY' as code
FROM table
</cfquery>
--------------------
<cfoutput query="test">#level#123<br /></cfoutput>
Results in MX:
0 123
Results in CF5:
0123
------------------------
However if the column "level" is actually in the database. .. we can trim
within the sql and we get the expected results when we output the query. While
we're only noticing in MX, it still may be a driver issue.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:265873
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
