Skip to main content
Inspiring
January 29, 2014
Question

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

  • January 29, 2014
  • 1 reply
  • 417 views

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.

This topic has been closed for replies.

1 reply

BACFLAuthor
Inspiring
January 29, 2014

Strike that, cancel it.  I forgot the in the code.  Thanks for looking though, have an irie day.