SSDN - Create multiple XML Files

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Emma Smith

Subject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 07:37 AM

I need to create an xml file for each record returned in a SQL Query - is this possible?

Minollo I.

Subject: Create multiple XML Files
Author: Minollo I.
Date: 19 Feb 2008 08:43 AM

It is possible using DataDirect XQuery (no need to specify SQL queries); for example, you can do something like this:

for $booksXML in collection("Books.dbo.booksXML")/booksXML
where contains($booksXML/title, "XML")
return
ddtek:serialize-to-url($booksXML, concat("file:///c:/myXMLBooks/", $booksXML/isbn, ".xml"), "")

That will create an XML file (named after the book's ISBN number) for each record in the database matching the condition that the book's title contains the word "XML".

Emma Smith

Subject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 09:31 AM

Thanks for that - if I only wanted to return certain columns for each record and create a separate xml file - how do I do this.

Thanks again

Minollo I.

Subject: Create multiple XML Files
Author: Minollo I.
Date: 19 Feb 2008 09:37 AM

You have all the flexibility of XQuery in your hands... You can completely control what you serialize; for example, to just output the "title" column wrapped in a "<myBook>" element, you can do:

for $booksXML in collection("Books.dbo.booksXML")/booksXML
where contains($booksXML/title, "XML")
return
ddtek:serialize-to-url(<myBook>{$booksXML/title}</myBook>,
concat("file:///c:/myXMLBooks/", $booksXML/isbn, ".xml"), "")

Emma Smith

Subject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 09:42 AM

Brilliant - thanks for your quick response

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.