6 Replies Latest reply on Jan 28, 2010 2:47 PM by Francisc

    Retrieving a row from a recordset using ActionScript

    cheftimo Level 2

      OK gurus/friends, this should be a piece of cake for a lot of you:


      I get a list of categories from the ColdFusion CFC on my server via this SQL query:


                        SELECT catID,catName,mnPrice,mxPrice,catCount

                        FROM someTable

                        ORDER BY catName


      When it comes in, I end up with an ArrayCollection that contains all the categories. Next, I need to get, from that ArrayCollection, via ActionScript, one of the categories. In SQL the query would be like:


                        SELECT *

                        FROM ArrayCollection

                        WHERE catID = someID


      How do I code this in AS? Loop through the AC? Something simpler?


      I would very much appreciate any ideas.