I posted this problem to [EMAIL PROTECTED] a week or so ago but I
haven't gotten a solution yet. So I'm trying flexcoders and
cf-talk....
I have an application that doesn't seem to be working properly.
Basically, I've got a query (in coldfusion 8) that returns a few
columns directly to flex via a remoteobject call.
Some of the columns are DECIMAL(10,2).
Flex is interpreting the results as strings instead of numbers, so
sorting data in my datagrid is failing to work properly.
Here's my query (in cf):
select
DISTINCT
GIFTAB1.ENTITY_ID,
'J. Q. Public' AS PREFERRED_NAME,
GIFTAB1.CREDTDAT,
CAST(GIFTAB1.LEGCRAMT AS money) AS LEGCRAMT,
GIFTAB1.SOFTAMT
FROM ...
Note that I'm casing LEGCRAMT to money, while I'm leaving SOFTAMT as
the regular type DECIMAL(10,2).
My response handler in the Flex app:
private function getMatchingGivingResult2(e:ResultEvent):void
{
var data = ArrayCollection(e.result);
dgGivingHistory.dataProvider=data;
refreshDataProvider();
}
If I put a break in there, I see the contents of data, and both
SOFTAMT and LEGCRAMT are strings. CREDTDAT is a date, as it should
be.
What's going on here? I need flex to understand that LEGCRAMT and
SOFTAMT are numbers, not strings, so that when those numbers are
sorted in the datagrid, they are sorted correctly.
Thanks.
--
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com
