tracker issue : CF-3935792

select a category, or use search below
(searches all categories and all time range)
Title:

cfgridupdate insert

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Robin Boudwin / Robin Boudwin (Robin Boudwin)

Created: 02/06/2015

Components: AJAX, UI Components

Versions: 11.0

Failure Type: Usability Issue

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Trivial / Most users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 1

Listed in the version 2016.0.02.299200 Issues Fixed doc
Verification notes: verified_ignore on September 30, 2019 using build 2016.0.02.299200 
Problem Description:

A cfgridcolumn in a cfgrid will not insert using cfgridupdate if the cfgridcolumn display is set to "no" (see below).  Does it have to be displayed to insert a row into the database?  If so, how can a hidden field be used?  This seems like a bug.

<cfgridcolumn name="pmspid" header="PMSPID" display="no" values="#url.pmspid#">

Steps to Reproduce:

Actual Result:

Expected Result:

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3935792

External Customer Info:
External Company:  
External Customer Name: Robin
External Customer Email:  
External Test Config: My Hardware and Environment details:



CF8 and CF11

Attachments:

Comments:

I have no idea what Product Area this would be under.
Comment by External U.
8538 | February 06, 2015 11:54:29 AM GMT
Can you please provide the below details: 1. CF Server version 2. Error message (Comment added from ex-user id:prk)
Comment by Adobe D.
8539 | February 26, 2015 07:19:54 AM GMT
1. CF 11 2. No error. It just doesn't enter that column value if the display is set to "no." I was hoping to use it like a hidden field by not displaying it.
Comment by External U.
8540 | February 26, 2015 07:48:43 AM GMT
In addition, the Flash format does not return any data. When the same cfgrid is used with the default applet format, it does return the data.
Comment by External U.
8541 | March 02, 2015 12:13:18 PM GMT
What is the status of this bug? It has been an ongoing issue for multiple versions of CF. When will it be fixed?
Comment by External U.
8542 | March 13, 2015 09:19:16 AM GMT
Hi Robin, I used the below code: <CFIF IsDefined("form.gridEntered") is True> <cfgridupdate grid="Artdisplay" tablename="ART" datasource="cfartgallery"> </CFIF> <cfquery name="qArtdisplay" datasource="cfartgallery" > Select ARTID, ARTNAME from APP.ART </cfquery> <cfdump var=#qArtdisplay#> <cfform name="frm"> <cfgrid name="Artdisplay" query="qArtdisplay" format="html" insert="true" delete="true" colHeaderBold = "Yes" selectMode = "EDIT" width="600" insertButton = "Insert a Row" deleteButton = "Delete selected row"> <cfgridcolumn name="ARTID" display="No" header="ARTID"> <cfgridcolumn name="ARTNAME" > </cfgrid> <cfinput type="submit" name="gridEntered" width="300"> </cfform> I am able to insert the data using default applet format. Verified in Build # 11,0,0,289974 and Build # 11,0,06,295053 on Windows 7 64-bit Please let me if you any specific testcase, where your facing the issue. (Comment added from ex-user id:prk)
Comment by Adobe D.
8543 | September 23, 2015 01:33:27 AM GMT
I duplicated your example, and I'm receiving errors: The submitted cfgrid form field is corrupt (name: __CFGRID__FRM__ARTDISPLAY value: __CFGRID__EDIT__=2?ARTID?Y?ARTNAME?Y?1?I???) ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem. Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0 Remote Address 127.0.0.1 Referrer http://localhost/ipmcenters_org/cropprofiles/admin/cfgrid.cfm Date/Time 24-Sep-15 03:56 PM Stack Trace coldfusion.filter.GridFieldProcessor$CorruptGridFieldException: The submitted cfgrid form field is corrupt (name: __CFGRID__FRM__ARTDISPLAY value: __CFGRID__EDIT__=2?ARTID?Y?ARTNAME?Y?1?I???) Server Product ColdFusion Version 11,0,06,295053 Tomcat Version 7.0.54.0 Edition Developer Operating System Windows 7 OS Version 6.1 Update Level C:/ColdFusion11/cfusion/lib/updates/chf11000006.jar Adobe Driver Version 5.1.3 (Build 000094) JVM Details Java Version 1.7.0_55 Java Vendor Oracle Corporation Java Vendor URL http://java.oracle.com/ Java Home C:\ColdFusion11\jre Java File Encoding Cp1252 Java Default Locale en_US File Separator \ Path Separator ; Line Separator Chr(13) User Name CIPM0175$ User Home C:\ User Dir C:\ColdFusion11\cfusion\bin Java VM Specification Version 1.7 Java VM Specification Vendor Oracle Corporation Java VM Specification Name Java Virtual Machine Specification Java VM Version 24.55-b03 Java VM Vendor Oracle Corporation Java VM Name Java HotSpot(TM) 64-Bit Server VM Java Specification Version 1.7 Java Specification Vendor Oracle Corporation Java Specification Name Java Platform API Specification Java Class Version 51.0
Comment by External U.
8544 | September 24, 2015 02:27:10 PM GMT
Please note that this code works on CF8. We are running two servers, so I was able to test it on both.
Comment by External U.
8545 | September 24, 2015 02:32:11 PM GMT
Hi Robin, The issue you addressed(The submitted cfgrid form field is corrupt) is fixed and we will try to roll out this fix in the next update (Comment added from ex-user id:prk)
Comment by Adobe D.
8546 | September 28, 2015 04:24:26 AM GMT
Wonderful news! Thank you.
Comment by External U.
8547 | September 28, 2015 10:14:25 AM GMT
Do you know when the next update will be released?
Comment by External U.
8548 | October 01, 2015 11:05:10 AM GMT
Java applet no longer viable as workaround as Chrome doesn't allow applet to run.
Vote by External U.
8553 | October 06, 2015 05:01:26 PM GMT
Issue is fixed and this fix will be available via updates. (Comment added from ex-user id:prk)
Comment by Adobe D.
8549 | February 25, 2016 04:36:14 AM GMT
test note
Comment by CFwatson U.
8550 | June 07, 2016 04:19:46 AM GMT
The fix for this bug is available as part of the early-access build for ColdFusion 2016 Update 2.
Comment by CFwatson U.
8551 | June 07, 2016 04:26:44 AM GMT
Unable to reproduce this issue (The submitted cfgrid form field is corrupt) on CF11 Update 7 (build 11.0.07.296330). Per Adobe's comments, that issue is specific to CF11 Update 6 - which explains why I don't see the issue on CF11 Update 7. Regarding cfgridupdate silently (no exception thrown) not inserting rows in db table, that issue also affects CF11 Update 7 and CF2016 Update 1 (build 2016.0.01.298513) - as I've commented on CF-4104997. That issue is supposedly fixed in CF2016 Update 2, and is probably why Adobe added a note here on CF-3935792 saying this ticket's fix is available in CF2016 Update 2. Thanks!, -Aaron
Comment by Aaron N.
8552 | July 24, 2017 03:24:20 AM GMT
Hi Adobe, I'm unable to reproduce this issue (The submitted cfgrid form field is corrupt) on CF2016 Update 1 (build 2016.0.01.298513), using your example code from your 09/23/2015 01:33:27 GMT comment. I am not sure why this ticket is listed in CF2016 Update 2's list of bugs fixed. In the aforementioned comment, you said "I am able to insert the data using default applet format." Then, the user replied saying your code threw "The submitted cfgrid form field is corrupt". I guess they removed format="edit" from your repro code, in order to render the Java applet variant of the grid, and submitting that is what caused that error. Since format="applet" has been deprecated, there is really no reason to look into this further. Thanks!, -Aaron
Comment by Aaron N.
31474 | September 30, 2019 06:01:30 AM GMT