Title:
Bug 79607:CF8's SerializeJSON() preserve case of query column name while CF9's SerializeJSON() return them in all uppercase
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)
Created: 08/27/2009
Components: Language, Functions
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 2
Problem:
CF8's SerializeJSON() preserve case of query column name while CF9's SerializeJSON() return them in all uppercase.
Method:
qry = queryNew("columnName1","columnName2");json = serializeJSON(qry);// cf8's json contains "columnName1"// cf9's json contains "COLUMNNAME1"
vmannebo:
<cfquery name="q" datasource="cfartgallery">
select artid,artname, description from art
</cfquery>
<cfset qry = queryNew("columnName1,columnName2")>
<h4>json (cfquery)</h4>
<cfoutput>#serializeJSON(q)#</cfoutput><hr>
<h4>json (querynew)</h4>
<cfoutput>#serializeJSON(qry)#<br></cfoutput>
Result:
SerializeJSON(queryObject) returns column names in all UPPER case, which breaks backwards compatible with CF8. when the JSON is consumed by case-sensitive Javascript. CF8 preserves the case of column names.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039794
External Customer Info:
External Company:
External Customer Name: Henry Ho
External Customer Email: 237A22C24921EDF5992015B9
External Test Config: 08/27/2009Attachments:
Comments: