Webmaster Forum / Flash / Flash Remoting / February 2004

Yes, it can be done. I took the following approach with Flash 2004 pro. ...

1. Use Flash remoting to access remote CFCs..

2. Create datagrid and dataset on the client form.

3. Within the dataset component inspector, add schema entries for each recordset field you want to view. Be careful -- references are case sensitive.

4. Within the dataset component inspector, bind the dataset.dataProvider to the the grid.dataProvider. and the dataset.selectedIndex to the grid.selectedIndex.

5. Using Actionscript, set up your grid attributes -- set grid.columnNames equal to the exact same fields you itemized in step 3. You can also set other properties such as grid.headerText and grid.width.

Since I was doing this for several record sets, I implemented a gridDataSet class which I instantiated for each grid.... This makes it easy to define and to control the datagrid ...

Object instantiation code...
===================

// set up BGGds dataset and the dataGrid on the BGG form...
var BGGdef_ar:Array = new Array();
BGGdef_ar.columns = ["bgProdPlat", "intBGGoalID", "strBGGoalName", "strBGGoalComment"];
BGGdef_ar.headers = ["Product Programs", "ID", "Goal", "Description or Comment"];
BGGdef_ar.widths = [150, 25, 100, 275];
var BGGDataSet = new gridDataSet(BGG, BGG_ds, BGGdef_ar);

Class definition...
============

// DataGridSupport Class v0.2 -- uses actionscript 2.0
// by Ned Asam, October 2003
//
// This class facilitates the use of data grids with Flash remoting
// and Cold Fusion CFCs.

class gridDataSet {
    var DataForm:Object;      // target form
    var DG:Object;    // target datagrid
    var DGds:Object;        // target dataset
    var DGdef:Array;        // defines grid columns
    var DGdelta:Array;        //
    var DGedit_ysn:Boolean = false;
    var DGqry_rs:RecordSet;    // Data captured from query
   
    function gridDataSet(curForm, curDGds, curDGdef) {
        this.DGedit_ysn = false;
        this.DataForm = curForm;
        this.DG = DataForm.Data_grid;
        this.DGds = curDGds;
        this.DGdef = curDGdef;
        this.DG.editable = false;
        this.DG.sortableColumns = false;
        this.DG.columnNames = this.DGdef.columns;
        for (var i = 0; i<this.DGdef.columns.length; i++) {
            this.DG.getColumnAt(i).headerText = DGdef.headers;
            this.DG.getColumnAt(i).width = DGdef.widths;
        }
    }
   
   
    function setDataSet(qryRecordSet) {
        this.DGqry_rs = qryRecordSet;
        this.DGds.dataProvider = this.DGqry_rs;
    }
    function setEditMode() {
        this.DGedit_ysn = true;
        this.DG.editable = true;
        this.DataForm.EditAbort_btn.label = "Abort";
        this.DataForm.NewUpdate_btn.label = "Update";
        this.DataForm.Delete_btn._visible = true;
        this.DataForm.Delete_btn.enabled = true;
    }
    function clearEditMode() {
        this.DGedit_ysn = false;
        this.DG.editable = false;
        this.DataForm.EditAbort_btn.label = "Edit";
        this.DataForm.NewUpdate_btn.label = "New";
        this.DataForm.Delete_btn._visible = false;
        this.DataForm.Delete_btn.enabled = false;
    }
   
   
//    ... other functions...
}

The constructor function defines the datagrid at the time it is instantiated, and the setDataSet(qryRecordSet) is called from the cfc query _Result  function.

I hope this helps... Let me know if you discover andy improvements...

I am now working on a way to do the cfc updates without dealing with XML...

Regards,

Ned