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.

       

      Regards,

       

      Carlos