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: