Thanks --<div><br></div><div>I also found out something else.</div><div><br></div><div>This SQL:</div><div><br></div><div><div>select i_billoflading_number, Consignee.clients, Shipper.clients</div><div>from </div><div>info_billoflading join info_clients as Consignee on consignees</div>
<div>join info_clients as Shipper on shippers</div><div>where i_billoflading_voyagenumber_ref = 'SS504'</div><div>order by i_billoflading_number for xml auto element </div><div><br></div><div>Results in this XML:</div>
<div><br></div><div><div>"<info_billoflading></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><i_billoflading_number><![CDATA[001]]></i_billoflading_number></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><Consignee></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[International Motors LTD]]></clients></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><Shipper></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[International Motors Ltd]]></clients></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></Shipper></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></Consignee></div><div></info_billoflading></div><div><info_billoflading></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><i_billoflading_number><![CDATA[002]]></i_billoflading_number></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><Consignee></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[Nite Oil LTD]]></clients></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><Shipper></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[PETROLEUM, TRAMMO ]]></clients></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></Shipper></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></Consignee></div><div></info_billoflading></div><div>
<info_billoflading></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><i_billoflading_number><![CDATA[004]]></i_billoflading_number></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><Consignee></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[Hawk Enterprises]]></clients></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><Shipper></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span><clients><![CDATA[BVI Gas Inc.]]></clients></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></Shipper></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></Consignee></div><div></info_billoflading></div><div><info_billoflading></div><div><br></div><div>What I was expecting is:</div><div><br>
</div><div><div><info_billoflading></div><div><span class="Apple-tab-span" style="white-space: pre; "> </span> <i_billoflading_number><![CDATA[004]]></i_billoflading_number></div><div><span class="Apple-tab-span" style="white-space: pre; "> </span></div>
<div><span class="Apple-tab-span" style="white-space: pre; "> </span><Consignee><![CDATA[Hawk Enterprises]]><span class="Apple-tab-span" style="white-space: pre; "> </span></Consignee></div><div><span class="Apple-tab-span" style="white-space: pre; "> </span><Shipper><![CDATA[BVI Gas Inc.]]></Shipper></div>
<div><br></div><div></info_billoflading></div><div><br></div><div>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.</div></div>
<div><br></div><div><br></div></div><div><br></div><div><br></div></div><div><br><br><div class="gmail_quote">On Tue, Nov 4, 2008 at 11:00 AM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:sunshine@public.kherson.ua">sunshine@public.kherson.ua</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="Ih2E3d">On 11/4/08 4:46 PM, "william humphrey" <<a href="mailto:shoreagent@gmail.com">shoreagent@gmail.com</a>> wrote:<br>
<br>
> That's not the case because it is using the wrapper for ordinary text field.<br>
<br>
</div>We changing this right now, William<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="Wj3C7c">Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina-beta mailing list<br>
<a href="mailto:Valentina-beta@lists.macserve.net">Valentina-beta@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-beta" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-beta</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a><br>
</div>