Hi there, Are those fault functions beeing called?
Anyway, since your cfcs are returning CFQueries you should bind your dataProviders to yourRo.yourMethod.result._items instead of yourRo.yourMethod.result. João Fernandes Secção de Desenvolvimento Departamento de Informática -----Original Message----- From: flexcoders@yahoogroups.com on behalf of aoi_zip Sent: Fri 25-Nov-05 8:17 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: flex 1.5 support Oracle 9? (source) -------------------------- system infomation --------------------------- OS windows 2003 coldfusion Version: 7,0,0,91690 Flex Version: 1.5 Oracle Version: 9.2.0.5.0 -------------------------------- result screenshot ------------------------------- // "getDataGrid_msAccess.mxml" result http://210.97.255.87/himton/img/getDataGrid_msAccess_result.png // "getDataGrid_Oracle.mxml" result http://210.97.255.87/himton/img/getDataGrid_Oracle_result.png -------------------------------- getDataGrid_Oracle.mxml ------------------------------- <?xml version="1.0" encoding="euc-kr"?> <mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" pageTitle="coldfusion remoting test page" themeColor="haloBlue" horizontalAlign="center" initialize="ro.getOracleUsers.send();" > <mx:RemoteObject id="ro" endpoint="http://localhost/flashservices/gateway" source="remoting_test.cfc.getUserData" fault="doFault(event)"> <mx:method name="getOracleUsers" result="GetDataSort (event.result);"/> </mx:RemoteObject> <mx:Script> <![CDATA[ private function doFault(event:Object):Void { alert("Error invoking CFC: " + event.fault.faultstring); } ]]> </mx:Script> <mx:VBox> <mx:DataGrid id="getUser_DG" width="100%" dataProvider="{ro.getOracleUsers.result}"> <mx:columns> <mx:Array> <mx:DataGridColumn columnName="name" headerText="Name" width="75" textAlign="center"/> <mx:DataGridColumn columnName="address" headerText="Address" width="85" textAlign="center"/> <mx:DataGridColumn columnName="tel" headerText="Tel" width="60" textAlign="center"/> </mx:Array> </mx:columns> </mx:Application> ------------------------------------ getDataGrid_msAccess.mxml ----------------------------------- <?xml version="1.0" encoding="euc-kr"?> <mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" pageTitle="coldfusion remoting test page" themeColor="haloBlue" horizontalAlign="center" initialize="ro.S_voice_L.send();" <mx:RemoteObject id="ro" endpoint="http://localhost/flashservices/gateway" source="remoting_test.cfc.getUserData" fault="doFault(event)"> <mx:method name="S_voice_L"> <mx:arguments> <query_num>{qn}</query_num> </mx:arguments> </mx:method> </mx:RemoteObject> <mx:Script> <![CDATA[ var qn:Number = 23; private function doFault(event:Object):Void { alert("Error invoking CFC: " + event.fault.faultstring); } ]]> </mx:Script> <mx:VBox> <mx:DataGrid width="80%" rowCount="23" dataProvider="{ro.S_voice_L.result}"> <mx:columns> <mx:Array> <mx:DataGridColumn columnName="wday" headerText="Date" textAlign="center"/> <mx:DataGridColumn columnName="wtime" headerText="Time" textAlign="center"/> <mx:DataGridColumn columnName="s_name" headerText="Name" textAlign="center" sortable="false"/> </mx:Array> </mx:columns> </mx:DataGrid> </mx:VBox> </mx:Application> ---------------------- getUserData.cfc ---------------------- <cfcomponent> <!-- call Oracle Datasource --> <cffunction name="getOracleUsers" returntype="query" access="remote" output="false"> <cfquery name="oracleUsersList" datasource="cf_remoting_test"> SELECT name, content, email FROM cf_remoting </cfquery> <cfreturn oracleUsersList /> </cffunction> <!-- call ms access Datasource --> <cffunction name="S_voice_L" returntype="query" access="remote" output="false"> <cfargument name="query_num" type="string" required="true" /> <cfquery name="voiceList" datasource="himton"> SELECT TOP #arguments.query_num# * FROM S_voice ORDER BY idx DESC; </cfquery> <cfreturn voiceList /> </cffunction> </cfcomponent> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<winmail.dat>>