It is the e4x path expression that returns the xmllist that contains the data you want to display in the list.
Its exact form depends on the fomat of the xml. Maybe "myListItemNodes" would be a more explanatory name? Tracy ________________________________ From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of toddad538 Sent: Tuesday, April 10, 2007 3:10 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: Issues with Datagrid non repeatinh HTTPService XML Result. Tracy, In your sample code there is the following line: var xlMyListData:XMLList = xmlResult.myListData; What does myListData reference? Is that a node/element in the xml data? Thanks, Todd Adelgren --- In flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> , "Tracy Spratt" <[EMAIL PROTECTED]> wrote: > > Sample code using HTTPService, e4x, handler function to populate a list item > > The DataGrid tag: > <mx:DataGrid id="dg" dataProvider="{_xlcMyListData}" .../> > > > The HTTPService tag: > <mx:HTTPService id="service" resultFormat="e4x" result="onResult(event)" fault="..../> > > Script block declaration: > import mx.rpc.Events.ResultEvent; > [Bindable]private var _xlcMyListData:XMLListCollection; > > Result Handler function: > private function onResult(oEvent:ResultEvent):void { > var xmlResult:XML = XML(event.result); //converts result Object to XML. can also use "as" operator > var xlMyListData:XMLList = xmlResult.myListData; //depends on xml format, is row data > _xlcMyListData = new XMLListCollection(xlMyListData); //wrap the XMLList in a collection > trace(_xlcMyListData.toXMLString()); //so you can see exactly how to specify dataField or build labelFunction > > ________________________________________ > From: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> [mailto:flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> ] On Behalf Of Tracy Spratt > Sent: Friday, March 30, 2007 1:35 PM > To: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> > Subject: RE: [flexcoders] Issues with Datagrid non repeatinh HTTPService XML Result. > > I think you will be happy with HTTPService. > > Specify resultFormat="e4x" in the HTTPService tag, otherwise flex converts the xml into an nested mx:Object structure. I find e4x XML much easier to work with. > > Don't bind directly to lastResult. It is too hard to debug. Instead use a result handler, and set an instance variable value(XMLListCollection) to event.result.STAFFREC in that, and bind the DataGrid dp to the instance variable. In the handler, you can trace the instance variable.toXMLString() to see exactly what yo have, and how to set the DataGridColumn dataField or labelFunction. > > I've written sample code tor this so many times I don't want to do it again right now, but post if you need more detail. > > Tracy > > ________________________________________ > From: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> [mailto:flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> ] On Behalf Of Olonade Tolulope williams > Sent: Friday, March 30, 2007 6:17 AM > To: flexcoders@yahoogroups.com <mailto:flexcoders%40yahoogroups.com> > Subject: [flexcoders] Issues with Datagrid non repeatinh HTTPService XML Result. > > I have a flex DBGrid client that was supposed to consume a web > service client. After much tweaking and coding. No success. I > switched to HTTPService and this was returning xml results. > But when DBGrid accepts the results they are all listed ONLY in row 1 > of the DBGrid. > Below is the mxml application as well as the web service I 1st used > and finally the httpservice routine done in C# 2.0 > Any help will be appreciated. > Thanks. > > <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml <http://www.adobe.com/2006/mxml> " > layout="absolute"> > <mx:HTTPService id="SDSearch" > url="http://localhost:53541/SDSearch.NET/Default.aspx <http://localhost:53541/SDSearch.NET/Default.aspx> " > showBusyCursor="true"> > <mx:request> > <byName>{NameBox.text}</byName> > <byPhoneNum>{PhoneBox.text}</byPhoneNum> > </mx:request> > > </mx:HTTPService> > <mx:DataGrid enabled="true" id="dataGrid" editable="false" > x="130" y="179" width="411" height="273" > dataProvider="{SDSearch.lastResult.STAFFREC}" > alternatingItemColors="[#fcf7e4, #ffffff]"> > <mx:columns> > > <mx:DataGridColumn headerText="Staff Name" > dataField="STAFFNAME"/> > <mx:DataGridColumn headerText="Phone Number" > dataField="PHONE_NUMBER"/> > > </mx:columns> > </mx:DataGrid> > <mx:Label x="28" y="88" text="Enter Name:"/> > <mx:Label x="28" y="131" text="Enter Phone No:"/> > <mx:TextInput id="NameBox" x="144" y="86" width="382"/> > <mx:TextInput id="PhoneBox" x="144" y="129" width="382"/> > <mx:Button x="247" y="530" label="Invoke Service" > click="SDSearch.send();"/> > > </mx:Application> > > public class Employee > { > public string STAFFNAME; > public string Phone_Num; > } > public partial class _Default : System.Web.UI.Page > { > protected void Page_Load(object sender, EventArgs e) > { > string byName, byPhoneNum; > string queryString, cnString; > OleDbDataAdapter adapter; > DataSet EmpData = new DataSet(); > cnString = ConfigurationManager.AppSettings > ["ConnStrDB"].ToString(); > > byName = Request.Params["byName"].ToString().Trim(); > byPhoneNum = Request.Params["byPhoneNum"].ToString().Trim > (); > > if (byPhoneNum.Length == 11) > { > queryString = "SELECT * FROM Employees WHERE > PHONE_NUMBER = '" + byPhoneNum + "'"; > adapter = new OleDbDataAdapter(queryString, cnString); > adapter.Fill(EmpData, "Employees"); > > Response.Write("<STAFFREC>"); > foreach (DataRow currrec in EmpData.Tables[0].Rows) > { > Response.Write("<STAFFNAME>" + currrec > ["STAFFNAME"].ToString() + "</STAFFNAME>"); > Response.Write("<PHONE_NUMBER>" + currrec > ["PHONE_NUMBER"].ToString() + "</PHONE_NUMBER>"); > } > Response.Write("</STAFFREC>"); > //XmlDataDocument dataDoc = new XmlDataDocument > (EmpData); > //return dataDoc; > } > else > { > queryString = "SELECT * FROM Employees WHERE > STAFFNAME LIKE '%" + byName + "%'"; > adapter = new OleDbDataAdapter(queryString, cnString); > adapter.Fill(EmpData, "Employees"); > > Response.Write("<STAFFREC>"); > foreach (DataRow currrec in EmpData.Tables[0].Rows) > { > Response.Write("<STAFFNAME>" + currrec > ["STAFFNAME"].ToString() + "</STAFFNAME>"); > Response.Write("<PHONE_NUMBER>" + currrec > ["PHONE_NUMBER"].ToString() + "</PHONE_NUMBER>"); > } > Response.Write("</STAFFREC>"); > > //XmlDataDocument dataDoc = new XmlDataDocument > (EmpData); > //return dataDoc; > } > } > } > > // the web service.. > [WebService(Namespace = "http://tempuri.org/ <http://tempuri.org/> ")] > [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] > public class Employee > { > public string STAFFNAME; > public string Phone_Num; > } > public class SDSearch : System.Web.Services.WebService > { > public SDSearch () { > > //Uncomment the following line if using designed components > //InitializeComponent(); > } > > [WebMethod] > public XmlDataDocument getStaffMatch(string byName, string > byPhoneNum) > { > string queryString,cnString; > OleDbDataAdapter adapter; > DataSet EmpData = new DataSet(); > cnString = ConfigurationManager.AppSettings > ["ConnStrDB"].ToString(); > > if (byPhoneNum.Length == 11) > { > queryString = "SELECT * FROM Employees WHERE PHONE_NUMBER > = '" + byPhoneNum + "'"; > adapter = new OleDbDataAdapter(queryString, cnString); > adapter.Fill(EmpData,"Employees"); > XmlDataDocument dataDoc = new XmlDataDocument(EmpData); > return dataDoc; > } > else //if (byName.Length > 3) > { > queryString = "SELECT * FROM Employees WHERE STAFFNAME > LIKE '%" + byName + "%'"; > adapter = new OleDbDataAdapter(queryString, cnString); > adapter.Fill(EmpData, "Employees"); > XmlDataDocument dataDoc = new XmlDataDocument(EmpData); > return dataDoc; > } > > } > > } >
