Reference cfsavecontent var in cfquery

[mcadle]

This code doesn't work, as it produces an unknown variable error. I have to be missing something simple. Thanks.

<cfsavecontent variable="updtTblPSDN">
if(_global.arrPassdown == undefined) _global.arrPassdown = grdPassdown.dataProvider.slice(0);
var arrPassdown = _global.arrPassdown;

for(var i = 0; i < arrPassdown.length; i++)
{
if(arrPassdown[ i ]['SUP_APPRVD'] == true)
{
var arrID = arrPassdown[ i ]['ID'];
<cfquery datasource="Oracle">
UPDATE INTEL.PASSDOWN SET SUP_APPRVD='Y' WHERE ID= arrID
</cfquery>
}
}
</cfsavecontent>

[Dan_Bracuk]

You are missing a script tag. You are also trying to pass a js (or as) variable to cf (at least that is what it looks like). You also have a cf tag inside a script. You are also using cfsavecontent to create a variable that won't have a value.

[mcadle]

I figured that out after I posted that you can't have actionscript execute cf code. So I wrote the values to an array and passed that as a variable to the page that needed it.

Thanks