coldfusion flash integration: couple of issues w/ filtering a grid -- coldfusion flash integration

couple of issues w/ filtering a grid

ckainc
8/17/2005 7:46:28 PM

coldfusion flash integration: The code is below...I know it's a lot, but I think the problem is me defining a
bunch of the same variables over and over again. The problem is I dont know
anything about AS..I pretty much just copy/pasted the code from
http://www.asfusion.com/blog/entry/filtering-a-cfgrid-as-you-type. Also I know
for sure that case is correct.
Thanks.

<cfsavecontent variable="actionReportFilter">
if(_global.arrMembers == undefined) _global.arrMembers =
gridReports.dataProvider.slice(0);
var arrMembers = _global.arrMembers;
var arrDisplay:Array = [];
var fortext = forInput.text.toLowerCase();
var selected = column.selectedItem.data;
var i = 0;
var n = 0;
gridReports.dataProvider.sortOn("facility");

while(i < arrMembers.length)
{
var item;
if(gridReports.dataProvider[n].facility == n - 1)
{
item = gridReports.dataProvider[n++];
}
else
{
item = arrMembers[i];
}
if(item[selected].substr(0,fortext.length).toLowerCase() == fortext)
{
arrDisplay.push(item);
}
i++
}
gridReports.dataProvider = arrDisplay;
</cfsavecontent>

<cfsavecontent variable="actionQualFilter">
if(_global.arrMembers == undefined) _global.arrMembers =
gridQuals.dataProvider.slice(0);
var arrMembers = _global.arrMembers;
var arrDisplay:Array = [];
var fortext = forInput.text.toLowerCase();
var selected = column.selectedItem.data;
var i = 0;
var n = 0;
gridQuals.dataProvider.sortOn("filedispname");

while(i < arrMembers.length)
{
var item;
if(gridQuals.dataProvider[n].filedispname == n - 1)
{
item = gridQuals.dataProvider[n++];
}
else
{
item = arrMembers[i];
}
if(item[selected].substr(0,fortext.length).toLowerCase() == fortext)
{
arrDisplay.push(item);
}
i++
}
gridQuals.dataProvider = arrDisplay;
</cfsavecontent>

<cfsavecontent variable="actionCheckFilter">
if(_global.arrMembers == undefined) _global.arrMembers =
gridChecks.dataProvider.slice(0);
var arrMembers = _global.arrMembers;
var arrDisplay:Array = [];
var fortext = forInput.text.toLowerCase();
var selected = column.selectedItem.data;
var i = 0;
var n = 0;
gridChecks.dataProvider.sortOn("filedispname");

while(i < arrMembers.length)
{
var item;
if(gridChecks.dataProvider[n].filedispname == n - 1)
{
item = gridChecks.dataProvider[n++];
}
else
{
item = arrMembers[i];
}
if(item[selected].substr(0,fortext.length).toLowerCase() == fortext)
{
arrDisplay.push(item);
}
i++
}
gridChecks.dataProvider = arrDisplay;
</cfsavecontent>

<cfquery name="reports" datasource="KillgDB">
Select m.facility, m.facilityid, f.filedispname, f.fileplacement,
f.facilityid, f.fileid
From master m, files f
Where f.facilityid=m.facilityid
Order by Facility
</cfquery>

<cfquery name="qualifications" datasource="KillgDB">
Select *
From files3
</cfquery>

<cfquery name="checklists" datasource="KillgDB">
Select *
From files2
</cfquery>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Edit or Delete a file.</title>
</head>
<body>
<cfform action="fileeditaction.cfm" format="flash" skin="halosilver">
<cfformgroup type="panel" label="Edit or Delete a File">
<cfformitem type="text">If you plan to delete a file do not change anything
else. Also, delete only one file per page at a time.</cfformitem>
<cfformgroup type="tabnavigator">
<cfformgroup type="page" label="Reports">
<cfformgroup type="horizontal">
<cfinput type="text" name="forInput" width="120"
onchange="#actionReportFilter#" label="Search for:">
<cfselect name="column" label="in:" onchange="forInput.text=''" width="120">
<option value="facility">Facility Name</option>
<option value="filedispname">File Display Name</option>
<option value="fileplacement">File Placement</option>
</cfselect>
</cfformgroup>
<cfgrid name="gridReports"
query="reports"
rowheaders="no"
height="300" selectmode="edit">
<cfgridcolumn name="Facility" header="Facility Name" select="no">
<cfgridcolumn name="FileDispName" header="File Display Name" select="yes">
<cfgridcolumn name="FilePlacement" header="File Placement" select="yes">
<cfinput type="checkbox" name="delreport_chk" label="Delete this file."
tooltip="T_T">
</cfgrid>
</cfformgroup>
<cfformgroup type="page" label="Qualifications/CE">
<cfformgroup type="horizontal">
<cfinput type="text" name="forInput" width="120"
onchange="#actionQualFilter#" label="Search for:">
<cfselect name="column" label="in:" onchange="forInput.text=''" width="120">
<option value="filedispname">File Display Name</option>
<option value="fileplacement">File Placement</option>
</cfselect>
</cfformgroup>
<cfgrid name="gridQuals"
query="qualifications"
rowheaders="no"
height="200" selectmode="edit">
<cfgridcolumn name="FileDispName" header="File Display Name" select="yes">
<cfgridcolumn name="FilePlacement" header="File Placement" select="yes">
<cfinput type="checkbox" name="delqual_chk" label="Delete this file."
tooltip="T_T">
</cfgrid>
</cfformgroup>
<cfformgroup type="page" label="Checklists and Forms">
<cfformgroup type="horizontal">
<cfinput type="text" name="forInput" width="120"
onchange="#actionCheckFilter#" label="Search for:">
<cfselect name="column" label="in:" onchange="forInput.text=''" width="120">
<option value="filedispname">File Display Name</option>
<option value="fileplacement">File Placement</option>
</cfselect>
</cfformgroup>
<cfgrid name="gridChecks"
query="checklists"
rowheaders="no"
height="200" selectmode="edit">
<cfgridcolumn name="FileDispName" header="File Display Name" select="yes">
<cfgridcolumn name="FilePlacement" header="File Placement" select="yes">
<cfinput type="checkbox" name="delchk_chk" label="Delete this file."
tooltip="T_T">
</cfgrid>
</cfformgroup>
</cfformgroup>
<cfinput type="submit" name="sub_btn" value="Submit" tooltip="SUBMIT THE
FORM ALREADY!">
</cfformgroup>
</cfform>