I'm using Coldfusion MX 7, and I've seen that ColdFusion can now bind many form elements to a CFgrid.
Can someone please tell me how to do the following:
I need to build a grid with data from a SQL query which will consist of 3-4 columns. Each column should consist of a drop-down box (single select combo box, not multi), populated with all the useable values, one of which will be selected based on the data from the query (a stored procedure will provide this data).
I also need to be able to dynamically add multiple rows to the grid with combo boxes. In other words, if the user clicks "add row," I want to increase the grid by another row without doing a submit and refresh to the grid, therefore, I'd like to be able to add more than a single row, then process all of the rows at once when a "submit" is finally requested.
I also need to be able to delete any checked rows (bind a checkbox in a column) to a piece of data, and not have the grid update/refresh each time a row is deleted; again, it needs to wait until final processing.
So, when the user finally clicks "update" or "process" or whatever we call it, the subsequent page will go through all of the rows on the grid, and simply recreate the record with all the new edits, leaving out anything that was selected for deletion, and including all of the new rows (with their combo box values) which had been added to the bottom of the grid.
I know this may sound a bit complicated, especially with binding the different form types into the grid (combo box, check box) which why I've given this 500 points. I'm in a bit of a hurry and need to get this going within two weeks. Thanks!
Start Free Trial
