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

cfgrid column results are switching places

Participant ,
Nov 05, 2014 Nov 05, 2014

Copy link to clipboard

Copied

We have just moved to a "new" server that is Windows Server 2008 R2.  I have installed CF 11.

There are two cfgrids and no code has changed with these grids.  Also, when running the grids on my localhost on my laptop I do not get the issue explained below.

One grid has a column "schoolyear" and the second grid has a columns "user role".

The results for these two are showing up under the other's columns.  i.e. "school year" shows the "user role" drop down and "User role" displays the "schoolyear" dropdown in the grid.

I thought it was perhaps a java issue and we have installed the latest version of java on the server.

Any help is greatly appreciated.

Thanks,

Brett.

Views

424

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

correct answers 1 Correct answer

Participant , Nov 24, 2014 Nov 24, 2014

This turned out to be an issue with an upgrade to CF 11.  Could not find any fix, so backed out to CF10.

Votes

Translate

Translate
Participant ,
Nov 24, 2014 Nov 24, 2014

Copy link to clipboard

Copied

This turned out to be an issue with an upgrade to CF 11.  Could not find any fix, so backed out to CF10.

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
Explorer ,
Nov 24, 2014 Nov 24, 2014

Copy link to clipboard

Copied

In case you are using javascript binding with your cfgrid control, you may notice a mismatch between the column names and the data they contain. This issue exists in CF11 and is recorded as bug #3712885.

The fix for this should be made available with HF3, the upcoming CF11 update, due soon.

As a workaround, you can probably order the columns in your data query the same, as the order of the columns in your grid, or vice versa.

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
Participant ,
Nov 25, 2014 Nov 25, 2014

Copy link to clipboard

Copied

Thank you for the information!  Glad to know it was a bug and not me. 🙂

B.

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

Copy link to clipboard

Copied

LATEST

I have further found this issue has to do with the first select box in each grid.  Here is the new information:

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.

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