1 Reply Latest reply on Jan 29, 2014 6:46 AM by BACFL

    Complex object types are getting up my nose.  Have a look...

    BACFL Level 1

      So, you do the research on how to get a CFGRID to update via SQL update because there isn't much control in the CFGRIDUPDATE function.   You follow the online assistance and still get:

      Complex object types cannot be converted to simple values.

       

      Here is the code, can someone help a guy out?  What am I missing?

       

      <cfif IsDefined('form.evalgrid.rowstatus.action')>

       

      <cfloop index="i" from="1" to="#ArrayLen(form.evalgrid.rowstatus.action)#">

       

      <cfquery name="updatevaluations" datasource="abcde">

      UPDATE evaluations

      SET pridefslascore = '#form.evalgrid.pridefslascore#'

      WHERE evaluationid = #form.evalgrid.original.evaluationid#

      </cfquery>

       

      </cfloop>

       

      </cfif>

       

      Forever thankful for a solution.

       

      B.