Filter CFgrid with Flash Remoting (Problem)

nightkiller211 · nightkiller211

:confused;

I can't seem to figure out why the filter as you type feature isn't working.
When I type some text in the text-box it clears the grid. I can't get it to
work with Flash Remoting.

<cfsilent>

<cfset memberList = queryNew("CustName,TechCode") />
</cfsilent>

<
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Populating a cfgrid with Flash Remoting</title>
</head>

<body>
<cfform name="myform" height="550" width="499" format="Flash" timeout="300"
onload="onFormLoad()">
<cfformitem type="script">
function onFormLoad(){
var listener:Object = {};

//put the controls in scope to avoid calling _root

var getData:Function = getData;
var search:Function = search;
var whereismytech:mx.controls.DataGrid = whereismytech;

listener.modelChanged = function(evt):Void {
alert('Data loaded... clear datagrid until department is selected');

whereismytech.removeEventListener('modelChanged',l istener);



search('',whereismytech,[]);
}

listener.search = search;

getData();

whereismytech.addEventListener('modelChanged',list ener);
}

function getData():Void{
<cfoutput>
//create connection

var connection:mx.remoting.Connection =
mx.remoting.NetServices.createGatewayConnection(
"http://#cgi.HTTP_HOST#/flashservices/gateway/";);
//declare service

var myService:mx.remoting.NetServiceProxy;
</cfoutput>

var responseHandler:Object = {};

//put the controls in scope to avoid calling _root

var whereismytech:mx.controls.DataGrid = whereismytech;

responseHandler.onResult = function( results: Object ):Void {
//when results are back, populate the cfgrid
whereismytech.dataProvider = results;

mx.managers.CursorManager.removeBusyCursor();
}

responseHandler.onStatus = function( stat: Object ):Void {
//if there is any error, show an alert
alert("Error while calling cfc:" + stat.description);
mx.managers.CursorManager.removeBusyCursor();
}

//get service, make sure you write the correct path
myService =
connection.getService("/Working-Remoting/xxxx/flashRemotingResponder",
responseHandler );
mx.managers.CursorManager.setBusyCursor();
//make call

myService.getMembers();
}


function search( term:String, grid:mx.controls.DataGrid, columns:Array ):Void {

var filterTerm:String = term.toString().toLowerCase();

if(_global.unfilteredData[whereismytech.id] == undefined){
if (_global.unfilteredData == undefined){
_global.unfilteredData = {};
}
_global.unfilteredData[whereismytech.id] = grid.dataProvider.slice(0);
}

if(filterTerm.length > 0) {

var filteredData:Array = [];

for(var i = 0; i< _global.unfilteredData[grid.id].length; i++) {
var item:Object = _global.unfilteredData[grid.id][i];
var added:Boolean = false;

for(var j = 0; j< columns.length; j++){
if(!added){
var value:String = item[columns[j]].toString().toLowerCase();
if(value.indexOf(filterTerm) != -1) {
filteredData.push(item);
added = true;
}
}
else {
break;
}
}
}

grid.dataProvider = filteredData;

}
else
{
if (_global.unfilteredData[grid.id] != undefined)
{
grid.dataProvider = _global.unfilteredData[grid.id];
}
}
}
</cfformitem>
<cfinput type="text" name="secondTerm"
onchange="search(secondTerm.text,whereismytech,[column.selectedItem.data])"
width="90" label="Filter by:">
<cfselect name="column" label="in:" onchange="secondTerm.text=''"
width="90">
<option value="CustName">CustName</option>
<option value="Job_ID">Job ID</option>
<option value="Supvsr">Supvsr</option>
<option value="CustAddr">CustAddr</option>
</cfselect>

<cfgrid name="whereismytech" query="memberList" height="200"
rowheaders="false" >
<CFGRIDCOLUMN NAME="TechCode" header="Tech Code">
<CFGRIDCOLUMN NAME="CustName" HEADER="CustName">

</cfgrid>
<cfinput type="button" name="getValues" value="Populate data grid" >
</cfform>
</body>
</html>

isn't this supposed to be in dot notation instead

myService = connection.getService("/Working-Remoting/xxxx/flashRemotingResponder", responseHandler );

Filter CFgrid with Flash Remoting (Problem)

Thread Tools

Display

Filter CFgrid with Flash Remoting (Problem)

Similar Questions and Discussions

CFGRID refresh and Flash Remoting Services

ColdFusion and Flash Remoting Gateway problem

problem with CFGRID flash data updating

Flash remoting, getService() problem with dotteddirectories

Flash Remoting Web Services problem HELP!!!!

Re: Filter CFgrid with Flash Remoting (Problem)

Posting Permissions