1 Reply Latest reply on May 12, 2008 4:20 PM by ntsiii

    XML with filter like Where in MySQL

    macpawel Adobe Community Professional
      Hello,

      I use dynamic generated XML file (from php+mysql), I'd like filter my results using DataGrid. How can I prepare query like:

      xml.node.data where data is filtred like in mysql where data=="Flex" or better data=comp.selectedItem.data

      Pawel

        • 1. Re: XML with filter like Where in MySQL
          ntsiii Level 3
          var sData:String = comp.selectedItem.data;
          var xmlFiltered:XML = xml.node.(data.text()==sData)[0]; //because e4x expressions return xmllist
          trace(xmlFiltered.toXMLString()); //to see what you have

          The above assumes you are actually dealing with XML and not the default resultFormat.

          Tracy