|
|
Home / Groups / ColdFusion Talk (CF-Talk)
Flex problem with Coldfusion 8I posted this problem to flex@houseoffusion.com 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 |
Mailing Lists
|
Latest Fusion Authority Articles
|
