Hi,
I am using the 'WddxRecordset Extensions' available
with the SDK from www.wddx.org. In the extensions
there is a method for sorting the WDDXRecordSet. It
sorts the recordset by the column you specify, or
using a custom sort function that you supply in a
custom JavaScript object.

Now here is something that the 'sort' method does. It
adds a new column to the sorted data, called
'preserveFieldCase'. If you sort in a loop, another
column with the same name is added. So now there are
multiple columns with the same name, namely
'preserveFieldCase'. 

Below is the serialized version of the WDDXRecordSet
after one sort. 

<wddxPacket version='1.0'><header/><data><recordset
rowCount='2'
fieldNames='preserveFieldCase,id_msg,msgtype,msgtext,tms_upd'><field
name='preserveFieldCase'><null/><null/></field><field
name='id_msg'><string>VR0009</string><string>VR0008</string></field><field
name='msgtype'><string>I</string><string>I</string></field><field
name='msgtext'><string>No new civil actions to be
processed exist for the specified case
type.</string><string>The selected case does not have
an image.</string></field><field
name='tms_upd'><dateTime>1999-7-26T0:0:0-5:0</dateTime><dateTime>2000-1-4T0:0:0-5:0</dateTime></field></recordset></data></wddxPacket>

Here is the serialized version after the second sort.
See the duplicate column name, namely
'preserveFieldCase'

<wddxPacket version='1.0'><header/><data><recordset
rowCount='2'
fieldNames='preserveFieldCase,preservefieldcase,id_msg,msgtype,msgtext,tms_upd'><field
name='preserveFieldCase'><null/><null/></field><field
name='preservefieldcase'><string></string><string></string></field><field
name='id_msg'><string>VR0009</string><string>VR0008</string></field><field
name='msgtype'><string>I</string><string>I</string></field><field
name='msgtext'><string>No new civil actions to be
processed exist for the specified case
type.</string><string>The selected case does not have
an image.</string></field><field
name='tms_upd'><dateTime>1999-7-26T0:0:0-5:0</dateTime><dateTime>2000-1-4T0:0:0-5:0</dateTime></field></recordset></data></wddxPacket>

This is not mentioned in the documentation. Also
another point to note is that this column is not added
if the WDDXRecordSet has only one row. The above
example has two rows.

Because of these columns that get added to the sorted
recordset, the CFCFML2WDDX tag throws an error...
*************************************
Error Diagnostic Information
unknown exception condition
TagCFWddx::doCFML2WddxStringTagCFWddx::execute
*************************************

This error is thrown because the WDDX2CFML conversion
was not correct.


Is anyone out there who has done this before or can
give me a solution to this problem?

Thanks in advance

Kedar Desai
Differential Technologies
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to