FOR XML ... RAW [ [WITH | USE] CDATA ]

[Ruslan Zasukhin]

On 11/4/08 5:47 PM, "william humphrey" <shoreagent at gmail.com> wrote:

> Thanks --
> 
> I also found out something else.
> 
> This SQL:
> 
> select i_billoflading_number, Consignee.clients, Shipper.clients
> from 
> info_billoflading join info_clients as Consignee on consignees
> join info_clients as Shipper on shippers
> where i_billoflading_voyagenumber_ref = 'SS504'
> order by i_billoflading_number for xml auto element

Well, I think Ivan have test joing of two tables,
And may be not yet on 3.

So can be a bug here. Please report it into Mantis ASAP.
May be today Ivan will be able fix it also.


> Results in this XML:
> 
> "<info_billoflading>
> <i_billoflading_number><![CDATA[001]]></i_billoflading_number>
> <Consignee>
> <clients><![CDATA[International Motors LTD]]></clients>
> <Shipper>
> <clients><![CDATA[International Motors Ltd]]></clients>
> </Shipper>
> </Consignee>
> </info_billoflading>
> <info_billoflading>
> <i_billoflading_number><![CDATA[002]]></i_billoflading_number>
> <Consignee>
> <clients><![CDATA[Nite Oil LTD]]></clients>
> <Shipper>
> <clients><![CDATA[PETROLEUM, TRAMMO ]]></clients>
> </Shipper>
> </Consignee>
> </info_billoflading>
> <info_billoflading>
> <i_billoflading_number><![CDATA[004]]></i_billoflading_number>
> <Consignee>
> <clients><![CDATA[Hawk Enterprises]]></clients>
> <Shipper>
> <clients><![CDATA[BVI Gas Inc.]]></clients>
> </Shipper>
> </Consignee>
> </info_billoflading>
> <info_billoflading>
> 
> What I was expecting is:
> 
> <info_billoflading>
>          <i_billoflading_number><![CDATA[004]]></i_billoflading_number>
> <Consignee><![CDATA[Hawk Enterprises]]> </Consignee>
> <Shipper><![CDATA[BVI Gas Inc.]]></Shipper>
> 
> </info_billoflading>
> 
> And without the CDATA stuff too that you are fixing. It looks like it is going
> to take very good SQL writing to produce the XML you want.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]