XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » Create multiple XML Files
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Checking for Values in an Arra... (3)
-> + Adding embedded functions (11)
-> + multiple DTPs at the same leve... (2)
-> + java.lang.OutOfMemoryError: Ja... (3)
-> + xml validation against wsdl (2)
-> + Using same Xquery (4)
-> + Changing name value pairs to t... (4)
-> + removing unwanted attributes r... (4)
-> + Repeated Crashing of System (2)
-> - Create multiple XML Files (5)
-> ->Create multiple XML Files
-> ->Create multiple XML Files
-> ->Create multiple XML Files
-> ->Create multiple XML Files
-> + Best xQuery engine? (2)
-> + Xquery outputs XML attributes ... (4)
-> + DataDirect SequeLink as a DB-t... (2)
-> + Using same xquery for 2 xml fi... (5)
-> + Performance of XQuery (2)
-> + fail to use Saxon Process for ... (4)
-> + Conditional statements in xque... (2)
-> + Option Declaration Using Saxon (2)
-> + Multiple option declarations (2)
-> + Importing modules with a Custo... (3)
-- Previous [241-260] [261-280] [281-300] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Emma SmithSubject: 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?
Postnext
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".
Postnext
Emma SmithSubject: 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
Postnext
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"), "")
Posttop
Emma SmithSubject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 09:42 AM
Brilliant - thanks for your quick response
   
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.