4 Replies Latest reply on Dec 3, 2014 10:51 PM by BACFL

    cfgrid column results are switching places

    BACFL Level 1

      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.

        • 1. Re: cfgrid column results are switching places
          BACFL Level 1

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

          • 2. Re: cfgrid column results are switching places
            Piyush Nayak Level 1

            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.

            • 3. Re: cfgrid column results are switching places
              BACFL Level 1

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

               

              B.

              • 4. Re: cfgrid column results are switching places
                BACFL Level 1

                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.