tracker issue : CF-3941413

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

CFdump errors on query names with commas

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): George Alsobrooks / George Alsobrooks (GEORGE ALSOBROOKS)

Created: 02/17/2015

Components: Debugging

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / Few users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 0

Problem Description:
If a column name has a comma in it, cfdump will error out instead of displaying the query.

Steps to Reproduce:
<!--- Comma after the word 'Last' --->
<cfquery name="qs_test">
	SELECT CURRENT_TIMESTAMP AS 'User Name (Last, First)'
</cfquery>
<cfdump var="#qs_test#">


Actual Result:
Receive the following error messages:
15:23:04.004 - coldfusion.util.RuntimeWrapper Exception - in E : line -1
	    [Table (rows 1 columns USER NAME (LAST, FIRST)): [USER NAME (LAST, FIRST): coldfusion.sql.QueryColumn@2adc6211] ] is not indexable by USER NAME (LAST
	    
15:23:04.004 - java.lang.IllegalArgumentException - in E : line -1
	    [Table (rows 1 columns USER NAME (LAST, FIRST)): [USER NAME (LAST, FIRST): coldfusion.sql.QueryColumn@2adc6211] ] is not indexable by USER NAME (LAST
	    
15:23:04.004 - java.io.FileNotFoundException - in D:/ColdFusion10/XXXXX/wwwroot/WEB-INF/exception/errorcontext.cfm : line 44
	    E (The system cannot find the file specified)


Expected Result:
cfdump should show the query results, regardless of the comma in the name.

Any Workarounds:
Don't use comma's in column names, but this is inconvenient since I'm then using cfspreadsheet to immediately export the query.  To workaround this I'll remove the commas during testing and then use the actual column names for production.

Other comments:
I did check the bugbase, wiki pages, and some general googling to see if this was documented somewhere.  I wasn't able to find that so I'm reporting it as a bug.

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

Watson Bug ID:	3941413

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

Coldfusion 10 Update 15 on Windows 2008R2 Server

Attachments:

Comments:

Seems to work fine in ColdFusion 11 although it does seem to be an issue in 10. Not sure we will be fixing this for CF 10 unless we hear more users asking for the same. Let us know if you see a concern with this. Thanks!
Comment by S P.
8390 | July 09, 2015 01:00:21 AM GMT
Thanks for looking into it. We're planning on going to CF11 in the next couple of months so I'm fine with it not being resolved in CF10.
Comment by External U.
8391 | July 09, 2015 04:43:02 AM GMT
Who uses commas in table or column names? This isn't a good idea.
Comment by External U.
8392 | July 09, 2015 04:25:32 PM GMT
Closing the bug. Thanks!
Comment by S P.
8393 | August 25, 2015 01:36:03 AM GMT