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

[william humphrey]

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

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.






On Tue, Nov 4, 2008 at 11:00 AM, Ruslan Zasukhin <sunshine at public.kherson.ua
> wrote:

> On 11/4/08 4:46 PM, "william humphrey" <shoreagent at gmail.com> wrote:
>
> > That's not the case because it is using the wrapper for ordinary text
> field.
>
> We changing this right now, William
>
> --
> 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]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20081104/5076039b/attachment.html