Highlighted

3 cfgrids on one page. Columns from grid 1,2 and 3 are swapping the first select box from each grid.

Participant ,
Dec 03, 2014

Copy link to clipboard

Copied

ColdFusion 11, hot fix 3 installed but did not help. There are no binds.


This one has been driving me crazy and I have finally figured out that it is the first column in each grid where there is a select box via "valuesdisplay" that is the issue. Select box results are switching grids!


Example of how it is coded to display:

Grid 1 - gridcolumn should have a dropdown with 1,2,3

Grid 2 - gridcolumn should have a dropdown with a,b,c

Grid 3 - gridcolumn should have a dropdown with x,y,z


However, the results in the dropdowns in the grids are:

Grid 1 - x,y,z (should be 1,2,3)

Grid 2 - 1,2,3 (should be a,b,c)

Grid 3 - a,b,c (should be x,y,z)


This only happens with the first dropdown for each grid. Any other columns with dropdowns do not have any issues and do not swap out to the wrong grid.


Sample of my code from the grids:
Grid 1:

<cfgrid name = "evalgrid"

  height="200"
  autowidth="no"

  font="arial" fontsize="12"

  query = "getevalfinal"

  SORT="Yes"

  selectmode="edit"

  format="html"
  insert="yes"

  delete = "#deletevalue#">


  <CFGRIDCOLUMN NAME="numberofschools" HEADER="numberofschools"

  HEADERALIGN="LEFT" DATAALIGN="LEFT"

  BOLD="Yes" ITALIC="No"

  SELECT="Yes" DISPLAY="Yes"

  HEADERBOLD="Yes" HEADERITALIC="No"
  VALUES = " ,NA,1,2,D"
  VALUESdisplay = "Blank,NA,1,2,D" valuesDelimiter=","
 
  width=50>

</cfgrid>


Second Grid:'

<cfgrid name = "SecondGrid"

  height="100" width="700"

  font="arial" fontsize="12"

  query = "getsecurity"

  SORT="Yes"

  selectmode="edit"

  format="html"
  insert="yes"

  delete = "#deletevalue#"
  autowidth="yes"
  >

  <CFGRIDCOLUMN NAME="userrole" HEADER="userrole"

  HEADERALIGN="LEFT" DATAALIGN="LEFT"

  BOLD="Yes" ITALIC="No"

  SELECT="Yes" DISPLAY="Yes"

  HEADERBOLD="YES" HEADERITALIC="No"
  VALUES = "#olduserrole#"
  VALUESdisplay = "#olduserrole#" valuesDelimiter=","
  WIDTH=300
  font="arial" fontsize="12">

</cfgrid>


In the above code, userrole values end up being in the wrong grid where numberofschools values should be and vice versa.


Appreciate any help!


B.

Views

141

Likes

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

3 cfgrids on one page. Columns from grid 1,2 and 3 are swapping the first select box from each grid.

Participant ,
Dec 03, 2014

Copy link to clipboard

Copied

ColdFusion 11, hot fix 3 installed but did not help. There are no binds.


This one has been driving me crazy and I have finally figured out that it is the first column in each grid where there is a select box via "valuesdisplay" that is the issue. Select box results are switching grids!


Example of how it is coded to display:

Grid 1 - gridcolumn should have a dropdown with 1,2,3

Grid 2 - gridcolumn should have a dropdown with a,b,c

Grid 3 - gridcolumn should have a dropdown with x,y,z


However, the results in the dropdowns in the grids are:

Grid 1 - x,y,z (should be 1,2,3)

Grid 2 - 1,2,3 (should be a,b,c)

Grid 3 - a,b,c (should be x,y,z)


This only happens with the first dropdown for each grid. Any other columns with dropdowns do not have any issues and do not swap out to the wrong grid.


Sample of my code from the grids:
Grid 1:

<cfgrid name = "evalgrid"

  height="200"
  autowidth="no"

  font="arial" fontsize="12"

  query = "getevalfinal"

  SORT="Yes"

  selectmode="edit"

  format="html"
  insert="yes"

  delete = "#deletevalue#">


  <CFGRIDCOLUMN NAME="numberofschools" HEADER="numberofschools"

  HEADERALIGN="LEFT" DATAALIGN="LEFT"

  BOLD="Yes" ITALIC="No"

  SELECT="Yes" DISPLAY="Yes"

  HEADERBOLD="Yes" HEADERITALIC="No"
  VALUES = " ,NA,1,2,D"
  VALUESdisplay = "Blank,NA,1,2,D" valuesDelimiter=","
 
  width=50>

</cfgrid>


Second Grid:'

<cfgrid name = "SecondGrid"

  height="100" width="700"

  font="arial" fontsize="12"

  query = "getsecurity"

  SORT="Yes"

  selectmode="edit"

  format="html"
  insert="yes"

  delete = "#deletevalue#"
  autowidth="yes"
  >

  <CFGRIDCOLUMN NAME="userrole" HEADER="userrole"

  HEADERALIGN="LEFT" DATAALIGN="LEFT"

  BOLD="Yes" ITALIC="No"

  SELECT="Yes" DISPLAY="Yes"

  HEADERBOLD="YES" HEADERITALIC="No"
  VALUES = "#olduserrole#"
  VALUESdisplay = "#olduserrole#" valuesDelimiter=","
  WIDTH=300
  font="arial" fontsize="12">

</cfgrid>


In the above code, userrole values end up being in the wrong grid where numberofschools values should be and vice versa.


Appreciate any help!


B.

Views

142

Likes

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
Dec 03, 2014 0

Have something to add?

Join the conversation