How do I then reference that array in my data grid on the UI side? Also how can I debug the results.. sort of like a CFDUMP in coldfusion?
--- In [email protected], "Muzak" <[EMAIL PROTECTED]> wrote: > > Do a trace in the result handler, using mx.utils.ObjectUtil > > public function handleQueryResult(event:ResultEvent):void{ > trace(mx.utils.ObjectUtil.toString(event.result)); > } > > run in debug mode. > > If I had to guess: > You're probably returning a cfquery from a DB. > If so, when accessing a cfc as WebService, query row field names are returned in Uppercase. > > Don't return cfquery's, but Array of Objects (structs) from cfc's. > > Loop through the query and assign each field to a Struct and store each Struct in an Array. > When setting each field, use Array access notation (see below): > > <cfset tmpObj["fieldNameWithMixedCase"] = fieldNameWithMixedCase /> > > It's a pain, but will hopefully get fixed in the next CF release. > > regards, > Muzak > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, March 07, 2007 1:50 AM > Subject: [flexcoders] exposing CFC's as web services > > > > I'm new to flex development and I'm just trying to do a simple data pull from a cfc using a web service. > > > > Query Result Function.. > > public function handleQueryResult(event:ResultEvent):void{ > > qResult=event.result as ArrayCollection; > > } > > > > Web Service.. > > <mx:WebService id="myService" wsdl="http://localhost/HelloWorld.cfc?WSDL"; useProxy="false"> > > <mx:operation name="getData" result="handleQueryResult(event);" fault="Alert.show(event.fault.message)"> > > </mx:operation> > > </mx:WebService> > > > > Data Grid.. > > <mx:DataGrid dataProvider="{qResult}" width="668" height="376" x="20" y="240"> > > > > Button... > > <mx:Button label="get projects" click="myService.getProjects()" x="377" y="199"/> > > > > > > I can get this to work fine if I use mx:RemoteObject... > > <mx:RemoteObject > > id="myService" > > destination="ColdFusion" > > source="CFC.HelloWorld" > > showBusyCursor="true" > > > > > > > But I'm using MX 6 so I need to use a webservice(right?) > > > > Anyhow.. any help w/ this would be appreciated. > > > > Thanks! > > -Jason > > >
