SSDN - using XQuery to keep all data in one XML doc

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Minollo I.

Subject: using XQuery to keep all data in one XML doc
Author: Minollo I.
Date: 02 Apr 2006 09:52 PM

>So is there a way using XQuery to bring these two xml documents together? If so how?

You can reference the second document using the doc() function, and use XPath to join the two. You can create an XPath expression that does something like...
doc("myOtherDoc.xml")//image[imageid = $imageid]

Or you can join the two documents in the context of a flwor:
for $a in doc("doc1.xml")/a/b, $b in doc("doc2.xml")/c/d)
where $a[someId] = $b[someId]
return ...

Minollo

TL W

Subject: using XQuery to keep all data in one XML doc
Author: TL W
Date: 05 Apr 2006 06:57 AM

I like the sound of the last one better. Would you be able to show me how to do this please in relation to my gallery here http://www.contemporarymultimedia.com/XML/index.xml

The 4 main XML docs are fine seperate but if you click on one of the thumbnails at the top i have seperate XML docs for each one and want try and eliminate that.

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.