2 Replies Latest reply on Jul 9, 2010 8:09 AM by docwisdom

    Change datagrid query from combobox

    docwisdom

      So I have a datagrid with a couple combo boxes down at the bottom. The combo boxes have static values. Based on the selection, I want the combo box to invoke the query in my CFC, passing the argument of what the selected value is. Then have the datagrid refresh with the new query.

       

      Anyone passed by any tutorials for this type of thing?

      I have seen some where you dump all the data to the grid and filter based on the combobox, but I would prefer to not have all of that overhead of pulling every record. I would like for the SQL to do the filtering based on the argument.

       

      Thanks!