tracker issue : CF-3909574

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

cfgrid: query bind is failing

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Piyush Kumar Nayak)

Created: 12/15/2014

Components: AJAX, UI Components

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: 11.0.03.292632 /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 0

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_probably_fixed on July 23, 2017 using build 2016.0.01.298513 
Problem:
cfgrid: query bind is failing with error "Query object being modified in not mutable".

Method:
observed on CF main build 11.0.03.292632 / Win 7x64.

<cfquery name = "GetCourses" dataSource = "cfdocexamples"> 
    SELECT * FROM CourseList 
</cfquery> 
<cfdump var=#GetCourses# abort=false>
<cfform> 
    <cfgrid name = "FirstGrid" format="html"
        query = "GetCourses"> 
    </cfgrid> 
</cfform>

Result:
Query object being modified in not mutable

The error occurred in C:/inetpub/cf11/cal.cfm: line 7
5 : <cfform> 
6 :     <cfgrid name = "FirstGrid" format="html"
7 :         query = "GetCourses"> 
8 :     </cfgrid> 
9 : </cfform>
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) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36
Remote Address  	127.0.0.1
Referrer  	
Date/Time  	15-Dec-14 05:22 PM
Stack Trace
at cfcal2ecfm37157720.runPage(C:/inetpub/cf11/cal.cfm:7) 

coldfusion.runtime.QueryFunction$QueryModificationException: Query object being modified in not mutable
	at coldfusion.runtime.QueryFunction.QueryAddColumn(QueryFunction.java:310)
	at coldfusion.tagext.html.form.GridTag.doEndTag(GridTag.java:1421)
	at cfcal2ecfm37157720.runPage(C:\inetpub\cf11\cal.cfm:7)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:496)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

Expected:

Workaround:

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

Watson Bug ID:	3909574

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

Unable to reproduce issue on CF11 Final (build 11.0.0.289822), CF11 Update 7 (build 11.0.07.296330) and CF2016 Update 1 (build 2016.0.01.298513). Note: This issue is listed in CF2016's list of Issues Fixed. Thanks!, -Aaron
Comment by Aaron N.
9413 | July 23, 2017 06:38:09 PM GMT