tracker issue : CF-3536920

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

A query object with a column type "object" becomes column type "longvarchar" after being converted to WDDX and back

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): John Bartlett / John Bartlett (wyntermoonwolf)

Created: 04/05/2013

Components: Core Runtime

Versions: 10.0

Failure Type: Crash

Found In Build/Fixed In Build: Final / 286871

Priority/Frequency: Major / Very few users will encounter

Locale/System: English / Platforms All

Vote Count: 0

Problem Description: Creating a query with a column of type "object" does not stay "object" if converted to WDDX and back. Adding a new query row with a CF Object throws and error after converting to WDDX and back

Steps to Reproduce:
Run the attached file WDDXError.cfm

Actual Result:
Error thrown:
Invalid data [Foo, Bar] for CFSQLTYPE CF_SQL_LONGVARCHAR. 

Expected Result:
New query row successfully created

Any Workarounds:

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

Watson Bug ID:	3536920

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

Windows XP SP3


  1. April 06, 2013 00:00:00: 1_WDDXError.cfm


Note: "longvarchar" is not a valid value when used with QueryNew()
Comment by External U.
15789 | April 05, 2013 02:48:49 PM GMT
Verified in CF10 update 11 and CF splendor latest build (Comment added from ex-user id:nawani)
Comment by Adobe D.
15790 | September 19, 2013 07:00:34 AM GMT