2 Replies Latest reply on Sep 13, 2006 4:19 PM by mcadle

    Reference cfsavecontent var in cfquery

    mcadle Level 1
      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>