tracker issue : CF-4198220

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

queryGetRow() should respect serialization.preserveCaseForQueryColumn

| View in Tracker

Status/Resolution/Reason: To Fix//EnhancementRequired

Reporter/Name(from Bugbase): Henry Ho / Henry Ho ()

Created: 12/22/2016

Components: Language, Functions

Versions: 11.0

Failure Type: Others

Found In Build/Fixed In Build: /

Priority/Frequency: Normal /

Locale/System: /

Vote Count: 2

queryGetRow() will always return a struct with all the keys in uppercase.  It would be great if serialization.preserveCaseForQueryColumn is set to true in Application.cfc, then it will return a struct with key in the case used in the query that created the query object.

e.g.

{code:java}
<cfquery name="test">
select id, name
from test
</cfquery>
<cfset row = queryGetRow(test, 1)>
<cfset row['key'] = createUuid()>
<cfset rowJson = serializeJson(row)>
{code}

Attachments:

Comments:

As just an FYI - in my testing, it appears as if queries made with queryGetRow will NOT show this bug, but queries made with 'real' db queries *will* show this bug.
Vote by Raymond C.
1397 | February 21, 2017 03:18:57 AM GMT