• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

Participant ,
Jan 29, 2014 Jan 29, 2014

Copy link to clipboard

Copied

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.

Views

365

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jan 29, 2014 Jan 29, 2014

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation