3 Replies Latest reply on Nov 25, 2009 10:03 AM by Prabh Singh

    Queries

    GeorgeWS Level 1

      I am using flex 3 and ColdFusion. I fill an ADG with an ArrayCollection from a RO call to my cfc. Works great. But my problem is that the query has 2 locations (North or South). So I have a combobox that has the 2 locations North or South. When one of these are selected everything is perfect but when I dont select either North or South and have the combo blank the data shows the 2 records one for the North and one for the South. I really want to sum the North and South but only when the combobox is blank. Whats the best way to do this? I am thinking my CFC could fire of the first query and then have a query of query; Im not sure how to get the 2 result sets. Then switch the dataprovider when the combobox is changed. If I could figure out how to get the 2 result sets from my RO call I think Id be all set.

       

      Thanks

       

      George