tracker issue : CF-4152876

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

WDDX crashes on XML from DB

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): James Mohler / James Mohler (James Mohler)

Created: 05/13/2016

Components: Functions

Versions: 2016

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Windows 7

Vote Count: 0

Listed in the version 2016.0.03.300466 Issues Fixed doc
Problem Description: I have an SQL Server DB table with an XML Field in it. When I query that DB then pass the results to WDDX, it crashes. This was not an issues in CF 9

Steps to Reproduce:

<cfquery name="qryData">
DECLARE @data xml = '<ul class="xoxo"><li><span><b>Config</b> [<var>1</var>]:</span><code>compliance</code></li></ul>'

SELECT @data AS Conf
</cfquery>

<cfwddx action = "cfml2wddx" input = "#qryData#" output = "wddxText">



Actual Result:

Hard error. See screenshot

"Invalid cast exception for WDDX recordset "

Expected Result:

Nice WDDX data

Any Workarounds:

In T-SQL, if the value is cast to CONVERT(varchar(max), Data) AS Config, then CF 2016 is OK

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

Watson Bug ID:	4152876

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



Vanilla install. CF 2016 update 1 has been applied. There were no issues with it. See screenshot

Attachments:

  1. May 14, 2016 00:00:00: 1_Capture.PNG
  2. May 14, 2016 00:00:00: 2_Capture2.PNG

Comments:

This issue is resolved now. The fix for this issue will be available as part of ColdFusion 2016 Update 3.
Comment by Nimit S.
2814 | August 18, 2016 07:59:03 AM GMT