XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Michael NevinsSubject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:53 PM
I do not seem to be able to return the same order I start with, can you please advise.

I need the <ForceData> element between the
<Data> element
**here** and the
<Data Format="Decorated"/>

I attached the xml file I started with and here is the query I am using?
*******************************************
<Connections>
{ /Connections/text() }
<Connection>
{ /Connections/Connection/text() }
<OutputTag>
{ /Connections/Connection/OutputTag/text() }
{
for $Data in /Connections/Connection/OutputTag/Data
return
if($Data/@Format = "Decorated") then
<Data Format="{ $Data/@Format }">
{ $Data/text() }
</Data>
else
<Data>
{ $Data/text() }
</Data>
}
<ForceData>
{ /Connections/Connection/OutputTag/ForceData/text() }
</ForceData>
</OutputTag>
</Connection>
</Connections>
******************************************************
Michael A. Nevins
Northrop Grumman
Electronic Systems


UnknownConnections.xml
Connections.xml

Postnext
Michael NevinsSubject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:56 PM
trying to attach the file

Michael A. Nevins
Northrop Grumman
Electronic Systems


UnknownConnections(1).xml

Postnext
Michael NevinsSubject: XQuery Format of XML code snippet
Author: Michael Nevins
Date: 27 May 2010 01:58 PM
cant attach file, so here it is.

Thanks,
<?xml version="1.0"?>
<Connections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file:///c:/BaseLineThread/Modules/Connections/Connections.xsd">
<Connection Name="Standard" RPI="20000" Type="Output" EventID="0" ProgrammaticallySendEventTrigger="false">
<InputTag>
<ForceData>00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00</ForceData>
<Data Format="Decorated">
<Structure DataType="AB:1756_DO:I:0">
<DataValueMember Name="Fault" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
<DataValueMember Name="Data" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
</Structure>
</Data>
</InputTag>
<OutputTag>
<Data>00 00 00 00</Data>
<ForceData>00 00 00 00 00 00 00 00 00 00 00 00</ForceData>
<Data Format="Decorated">
<Structure DataType="AB:1756_DO:O:0">
<DataValueMember Name="Data" DataType="DINT" Radix="Binary" Value="2#0000_0000_0000_0000_0000_0000_0000_0000"/>
</Structure>
</Data>
</OutputTag>
</Connection>
</Connections>



Michael A. Nevins
Northrop Grumman
Electronic Systems

Posttop
Minollo I.Subject: XQuery Format of XML code snippet
Author: Minollo I.
Date: 27 May 2010 02:17 PM
I can see your attachment.

This is one way of doing what you are looking for; whether that's correct or not it depends on what the structure of the source and target XML documents are in general (and not just in this particular case):

<Connections>
{ /Connections/text() }
<Connection>
{ /Connections/Connection/text() }
<OutputTag>
{ /Connections/Connection/OutputTag/text() }
{
for $Data in /Connections/Connection/OutputTag/Data
return
if($Data/@Format = "Decorated") then
<Data Format="{ $Data/@Format }">
{ $Data/text() }
</Data>
else
(<Data>
{ $Data/text() }
</Data>,
<ForceData>
{ /Connections/Connection/OutputTag/ForceData/text() }
</ForceData>)
}
</OutputTag>
</Connection>
</Connections>

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.