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

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


      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#







      Forever thankful for a solution.