Skip to main content
deepthit36620990
Participating Frequently
September 14, 2016
Question

CFGrid combobox list getting mixed up with other grids in the page

  • September 14, 2016
  • 1 reply
  • 859 views

Hi,

Currently we have ColdFusion 2016 Update 1 installed on our deployed server. After we upgraded our CF version from 9 to 2016, all cfgrids combobx columns started behaving a bit strange. Grid combobox columns are not displaying the exact values defined in cfgridcolumn values and valuesdisplay list. We have some links on the grid that opens up a pop-up with cfgrid. This grid combobox list data is getting mapped to the parent grid combobox list.

For ex: If the parent grid second column is a combobox and values="true,false" and the pop-up grid second column combobox values="FE,TSE,TS", If I try to edit pop-up grid second column, true/false is appearing in the combobox list.

Strangely this is happening with all the grids that have editable combobox columns. Can you please help me with the

Grids settings is something like:

<cfset gridArgs = structNew()>
<cfset gridArgs.name = "LoansGrid">
<cfset gridArgs.pageSize = 20>
<cfset gridArgs.format = "html">
<cfif SERVER.ColdFusion.ProductVersion lt 9>
<cfset gridArgs.width = "99%">
</cfif>
<cfset gridArgs.autowidth = "no">
<cfset gridArgs.bindOnLoad = "true">
<cfset gridArgs.bind = "cfc:XXX.MVP.components.Manager.getRecords({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},{Filter})">
<cfset gridArgs.stripeRows = true>
<cfset gridArgs.selectColor = "##D9E8FB">
<cfset gridArgs.selectmode = "edit">
<cfset gridArgs.onchange = "cfc:XXX.MVP.components.Manager.editRecord({cfgridaction},{cfgridrow},{cfgridchanged})">

<style>
td div, table div, form div { margin:0; } .x-grid-header { margin:0; } .x-grid-hd-row td { line-height:normal; }
</style>

<cfform name="EEEForm">

<cfinput type="hidden" name="Filter" value="#id#">

<cfgrid attributeCollection="#gridArgs#">
<cfgridcolumn name='Links' header='Links' display="true" width="170" select="no">
<cfgridcolumn name='Record_ID' header='Record ID' display="false" select="no">
<cfgridcolumn name="ID" header="ID"  display="false" select="no">
<cfgridcolumn name="Number" header="Number"  display="true" bold="yes">
<cfgridcolumn name="IncludeInRun" header="Include in Run"  display="true" values="1,0" valuesdisplay="True,False">
<cfgridcolumn name="Status" header="Status"  display="true">
<cfgridcolumn name="LastName" header="Last Name"  display="true">
<cfgridcolumn name="ProductType" header="Product Type"  display="true" values="#productType#" valuesdisplay="#productType#">
<cfgridcolumn name="PropertyType" header="Property Type"  display="true" values="#propertyType#" valuesdisplay="#propertyType#">
........
</cfgrid>
</cfform>

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    Community Expert
    September 18, 2016

    deepthit36620990 wrote:

    For ex: If the parent grid second column is a combobox and values="true,false" and the pop-up grid second column combobox values="FE,TSE,TS", If I try to edit pop-up grid second column, true/false is appearing in the combobox list.


    <cfgridcolumn name="IncludeInRun" header="Include in Run" display="true" values="1,0" valuesdisplay="True,False">

    Could you verify that you are comparing values with values and valuesdisplay with valuesdisplay? In other words, something like this

    <cfgridcolumn name="col_x" header="hdr_x" display="true" values="1,0" valuesdisplay="True,False">

    <cfgridcolumn name="col_y" header="hdr_y" display="true" values="FE,TSE,TS" valuesdisplay="varName1,varName2,varName3">

    deepthit36620990
    Participating Frequently
    September 19, 2016

    Yes. I am comparing values with values and Valuesdisplay with valuesdisplay.

    BKBK
    Community Expert
    Community Expert
    September 19, 2016

    deepthit36620990 wrote:

    Yes. I am comparing values with values and Valuesdisplay with valuesdisplay.

    I asked because you mentioned

    values="1,0"

    values="true,false"

    valuesDisplay="true,false"

    Could you show us the entire code for both grids?