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.
This turned out to be an issue with an upgrade to CF 11. Could not find any fix, so backed out to CF10.
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.
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.
Copy link to clipboard
Copied
Thank you for the information! Glad to know it was a bug and not me. 🙂
B.
Copy link to clipboard
Copied
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.