and when I view the page my datagrid is empty, but it does
change the number of rows in the grid when I change the value in
the drop downs. I'm just starting flex so there may be errors in
the dataProvider section of the data grid declaration. If anyone
has any ideas/suggestions it would be much appreciated
I always advise using a result handler function instead of
binding directly to the result because binding is so hard to debug.
I also advise using resultFormat="e4x" because the XML object
is easier to work with than the default Object. For example, in a
handler function you can use toXMLString() to see exactly what your
data looks like. This is much harder if you are using mx:Object.
Now, I don't know CF, so I can't tell what kind of object the query
is returning, so the xml format might not work for you.
Finally, the column display depends on the structure of your
data. For dataField specifications to work, the specified field
must be a top-level property of the item object. If it is nested in
another object, yo will have to use a labelFunction.
Whatever, you MUST know exactly what your data structure is
in order to consume it successfully. Hence the result handler
function, where you can alert or trace as needed.